CountIf with Multiple Criteria + Mutli-Sheet Reference

luke_morales

Hello,

I am trying to count total items in "Medium" item in PRIORITY Column that also have a status of "Done" in the STATUS Column. Both PRIORITY and STATUS columns are in the SCRUM: Communications sheet.

Here's my current formula (which is reciving a #INCORRECT ARGUMENT SET error):

=COUNTIF({ SCRUM: Communications PRIORITY Column}, "Medium", { SCRUM: Communications STATUS Column}, "Done")

Any pointers?

Devin Lee

Just missing the "S" on COUNTIFS

=COUNTIFS(PRIORITY:PRIORITY, "Medium", STATUS:STATUS, "Done")

Devin Lee

Just missing the "S" on COUNTIFS

=COUNTIFS(PRIORITY:PRIORITY, "Medium", STATUS:STATUS, "Done")

luke_morales

HA! Thank you, @David Lee. So easy.