counting numbers

[showry]

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.

 

[Mike H]

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.

 

[Jarek Kujawa]

=SUMPRODUCT((A1:A6="anil")*B1:B6)

 

[showry]

Hi,

you have given me the

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

Regards,
Anil.