Count IFS

Options

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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!