Count between two columns if looking for non-blanks in one of them

Nancy Heater
Nancy Heater ✭✭✭✭
edited 08/27/21 in Formulas and Functions

Hi all.

We have (2) columns: Tracking and Project/PO.

We need to count all of the cells in "Tracking" that have a tracking number i.e. are NOT blank, but at the same time NOT counting any cells from a row that also contain the word "Lab" in "Project/PO"

These are the two versions we have tried, based on other similar formulas, but it is not working.



Thanks in advance for the help, as always!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!