Count if for multiple columns
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
Check out the Formula Handbook template!