Hi ....

Looking for help on a formula.
Looking to count number of "yes" in a column but split by a team number, and week number.

ie - if a row in column A has a 1 in it and a row in Column B has a 4 in it, then count the number of "Yes" in the row of column C that matches the criteria.

think its a sumproduct equation but not having too much joy with it at the moment.

thanks !