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.