COUNTIFS formula help

Hello Smartsheet Community,

I'm trying to get a COUNTIFS formula that tallies

Column1 equals "CDB"

Column2 is not blank

Column 3 does not contain the word "Prime" OR "Early"

I've got this part:

=COUNTIFS(Column1:Column1, "CDB", Column2:Column2, <>"")

But I can't figure out how to add the OR statement for Column 3

Any help or suggestions would be much appreciated!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!