Count IFS

Stephanie Bauder

I am trying to build a formula that will count the number first based one the COE name, then to give a number on each disposition status. I thought it would be something like:

=COUNTIF({Policy Project Status Report Range 3}, "Global Rewards"),({Policy Project Status Report Range 1}, "Keep/Enterprise")

OR

=COUNTIFS([Assigned To]:[Assigned To], "Global Rewards"), AND([Document Disposition Status]:[Document Disposition Status], "Keep/Enterprise"))

But that isn’t working.

Paul Newcome

You don't need the AND statement in your COUNTIFS and it is all one function so no need for the early closing parenthesis.

=COUNTIFS([Assigned To]:[Assigned To], "Global Rewards", [Document Disposition Status]:[Document Disposition Status], "Keep/Enterprise")