View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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?