Counting from one column by specific identifier

[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?

 

[stjori]

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?

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

Also, have a look at pivot tables.

 

[Bob Phillips]

=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)