Count if for multiple columns

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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!