Count if for multiple columns

Nicolette Thomas

Hi all,

I'm trying to create a count if formula to find data in two columns.

For instance I have two columns. One column is status and the other is for discipline.

I am trying to count if the status is "complete" and the discipline is "marketing". I need the formula to tell me what is the total count in the Smartsheet. Anyone have a formula I could use? Is the "Count If" the right formula to use for this?

Paul Newcome

You actually want the COUNTIFS (with the S on the end) to incorporate more than 1 range/criteria set.

=COUNTIFS(Status:Status, "Complete", Discipline:Discipline, "Marketing")

Nicolette Thomas

THIS WORKS! Thank you so much!

Paul Newcome

Happy to help. 👍️