Trying to do a COUNTIF two columns fall under a certain criteria

Julia Meder

I am trying to create a formula in my sheet summary that will provide the count for a completed project with a certain firm. I only want the formula to provide the count if it is both status green and analyst firm gartner. Status being the one column and analyst firm being the other. I keep getting the error: #UNPARESABLE. Here is my current formula:

=COUNTIF([Analyst Firm]:[Analyst Firm], "Gartner")AND(Status:Status, "Green"))

Mike Wilday

You would want to use a COUNTIFS statement instead. Countifs allows for multiple ranges and criterion.

=COUNTIFS([Analyst Firm]:[Analyst Firm], "Gartner", Status:Status, "Green" )

See the following article for more on Countifs

https://help.smartsheet.com/function/countifs

Mike Wilday

You would want to use a COUNTIFS statement instead. Countifs allows for multiple ranges and criterion.

=COUNTIFS([Analyst Firm]:[Analyst Firm], "Gartner", Status:Status, "Green" )

See the following article for more on Countifs

https://help.smartsheet.com/function/countifs

Julia Meder

WOW, so helpful. Thank you Mike!

Mike Wilday

Absolutely! So glad I could help. Have a great day! Thanks for accepting my answer!