Just for clarification, here is an example of what I want:

Name: Male: Brown: Size:

Apple Y Y Big
Dog Y Y Small
Dog N Y Small
Dog N Y Medium
Banana Y N Small
Cat N N Big
Apple Y N Big
Dog Y Y Small
Dog Y N Small
Cat Y N Medium

So, for example, I would want the count of the Small Dogs that are both Male
and Brown, which would be 2 in the above case using one formula pulling from
a large data pool with many more columns than these. Thanks!

"Jonathan" wrote:

Hi all,

I'm trying to use the countif function to count the number of items that
have a specific name (column A), that has a "Yes Flag" for another field
(Column B)(marking only the items that have a Y), and then a certain "status"
(Column C).

I want the order of the function to go as follows: First, locate the trades
with the specific name (which I can do using just the countif function), then
check if these "flags" meet my criteria.

A problem I ran into is that there are certain fields that I don't want to
be used in the data pool I'm using, so my range can't be the entire field.
This is because there would be overlaps in the "name" field that I want to
use because these names come up in other fields as well.

Thanks.