COUNTIF formula help

System

This discussion was created from comments split from: Using COUNTIF in Sheet Summary.

Alicia Beckman

Can someone help me with a similar COUNTIF issue. I want a total of projects that have an MSP Status of "Active Started" or "Scheduled For Future Start Date". The formula works in excel but not in the Sheet Summary field in my spreadsheet. I'm getting #INVALID OPERATION

=SUM(COUNTIFS([MSP Status]:[MSP Status], {"Active/Started","Scheduled For Future Start Date"}))

Paul Newcome

@Alicia Beckman Try this instead:

=COUNTIFS([MSP Status]:[MSP Status], OR(@cell = "Active/Started", @cell = "Scheduled For Future Start Date"))

Alicia Beckman

That worked! Thank you so much! :)

Paul Newcome

Happy to help. 👍️