Counting from one column by specific identifier

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Say I have two columns, Dog Breeds and Male/Female. In Dog Breeds there are
25 different types, in Male/Female I have either M or F. The actual problem
is alot more difficult than this, but I'm trying to simplify the issue to get
the result I want.

I want to enter a formula that says IF column Dog Breed equals "German
Shepherd" Count Males to get a total of Male German Shepherds.

Can anyone give me some help?
 
Say I have two columns, Dog Breeds and Male/Female. In Dog Breeds there are
25 different types, in Male/Female I have either M or F. The actual problem
is alot more difficult than this, but I'm trying to simplify the issue to get
the result I want.

I want to enter a formula that says IF column Dog Breed equals "German
Shepherd" Count Males to get a total of Male German Shepherds.

Can anyone give me some help?
Click to expand...

You could try something like =SUMPRODUCT(--(A1:A10="German
Shepherd"),--(B1:B10="Male")).

Also, have a look at pivot tables.
 
=SUMPRODUCT(--(A2:A200="German Shepherd"),--(B2:B200="Male"))



--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top