Counting various statuses

alexandra.richardson

Hi! I want to be able to count how many of my various tasks in my sheet have each status, such as "In Progress," "Not Started," "On Hold, "Complete." I've tried some COUNTIF options and each time get unparseable. Would love some formula help!

Darren Mullen

@alexandra.richardson Post the formula that is giving you the unparseable error.

alexandra.richardson

I tried this one:

=COUNTIFS({Task}, Task@row, {Status}, "In Progress")

Carson Penticuff

Depending on how your sheet is setup, it will be something similar to:

=COUNTIFS([Status]:[Status], "In Progress")