COUNTIF formula

nicolee

I'm trying to add a formula to a metrics sheet to count the number of issues by both a project name name and status. Project name and Status are columns in the worksheet I'm referencing.

In this case the project is called DREAM and the primary column on my the metrics sheet lists the options resolved and unresolved

I tried this but it's giving me #incorrectargumentset

=COUNTIF({Study}, "DREAM", {Status}, [Primary Column]@row)

Any suggestions on how to write this properly?

Paul Newcome

You just need to change the function to a COUNTIFS (with the "S" on the end) so that you can include multiple range/criteria sets.

I only ever use COUNTIFS because it works with just one range/criteria set, and I don't have to worry about forgetting to update the main function in the event that I need to add to it. Same with SUMIFS instead of SUMIF.