Counting from one column by specific identifier
 

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?

Counting from one column by specific identifier
 

On Dec 4, 7:53 pm, Mike wrote:
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.

Counting from one column by specific identifier
 

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



"Mike" wrote in message
...
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?