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.


"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.
.

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


On 9 Kwi, 13:44, 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.

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