counting numbers

  • Thread starter Thread starter showry
  • Start date Start date
S

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.
 
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.
 
Hi,

you have given me the

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

Regards,
Anil.
 
Back
Top