Prev: What does the number 1.26E-23 mean? Is it a large or small num
Next: "seeing" hyperlinks in a worksheet
From: showry on 9 Apr 2010 07:44
Hi All,

I have a Query like This. Pls Give your Suggestions.
DATA:
anil 0
sunil 1
anil 1
sunil 0
anil 1
sunil 0


Ans:
Anil 2
Sunil 1 I need to count the numbers against name which number is more
that 0.

Regards,
Anil.
From: Mike H on 9 Apr 2010 08:32
Maybe this

=SUMIF(A1:A6,"Anil",B1:B6)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"showry" wrote:

> Hi All,
>
> I have a Query like This. Pls Give your Suggestions.
> DATA:
> anil 0
> sunil 1
> anil 1
> sunil 0
> anil 1
> sunil 0
>
>
> Ans:
> Anil 2
> Sunil 1 I need to count the numbers against name which number is more
> that 0.
>
> Regards,
> Anil.
> .
>
From: Jarek Kujawa on 9 Apr 2010 09:00
=SUMPRODUCT((A1:A6="anil")*B1:B6)


On 9 Kwi, 13:44, showry <anilshowre...(a)gmail.com> wrote:
> Hi All,
>
> I have a Query like This. Pls Give your Suggestions.
> DATA:
> anil    0
> sunil  1
> anil    1
> sunil   0
> anil    1
> sunil   0
>
> Ans:
> Anil  2
> Sunil 1  I need to count the numbers against name which number is more
> that 0.
>
> Regards,
> Anil.

From: showry on 13 Apr 2010 07:41
Hi,

you have given me the

sumif and sumproduct which is not helping me to counting the numbers..
Pls any other options?

Regards,
Anil.


On Apr 9, 5:32 pm, Mike H <Mi...(a)discussions.microsoft.com> wrote:
> Maybe this
>
> =SUMIF(A1:A6,"Anil",B1:B6)
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
> "showry" wrote:
> > Hi All,
>
> > I have a Query like This. Pls Give your Suggestions.
> > DATA:
> > anil    0
> > sunil  1
> > anil    2
> > sunil   0
> > anil    1
> > sunil   0
>
> > Ans:
> > Anil  2
> > Sunil 1  I need to count the numbers against name which number is more
> > that 0.
>
> > Regards,
> > Anil.
> > .

 | 
Pages: 1
Prev: What does the number 1.26E-23 mean? Is it a large or small num
Next: "seeing" hyperlinks in a worksheet