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?

On Dec 4, 7:53 pm, Mike <M...@discussions.microsoft.com> 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.

=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" <(E-Mail Removed)> wrote in message
news:BDDBFE34-06A6-4097-B873-(E-Mail Removed)...
> 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?
>