Taking Counts

[sathishkm]

Hi All,

I have a Accountname list and city. Now I have to take the counts of the Accountname based on the city. Is there any formula? Please check the attachment.

[daffodil11]

=SUMPRODUCT(($A$2:$A$18=A2)*($B$2:$B$18=B2))

or

=COUNTIFS($A$2:$A$18,A2,$B$2:$B$18,B2)

And paste down

[sathishkm]

Thanks for the forumla