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