I am working on counting if criteria is met, but want to skip if the cell is blank. I have two formulas that work separately, but when I combine them I get an error.
=COUNTIF([Connected to Confirmed]@row, "<7")
Skipping the blank cells
=IFERROR([Connected to Confirmed]@row, "")
I'm not sure what I'm doing incorrectly but I have the formulas counting based on a formula from another cell.
Help Article Resources
Check out the Formula Handbook template!