Count two columns of a sheet that each match specific criteria


Hello, I am trying to create a count that both matches one of 4 specific project initiatives and shows approved in another column.

Example: Lead by Example (One Column) and the Status is "Approved" in another column.

Best Answer

  • Eric Law
    Eric Law ✭✭✭✭✭✭
    Answer ✓

    @Bob Schweighart you just need the COUNTIFS formula and put those 2 criterion in it. Are they distinct counts for the 4 different projects? If so, that is easier. If you are counting all 4, then you need to decide on an imbedded OR or a NOT.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!