Formulas

Deb Allen

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

=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.

Paul Newcome

Try something along the lines of...

=COUNTIFS([Column Name]:[Column Name], AND(@cell <> "", @cell < 7))

Deb Allen

That returns a value of 10...

Paul Newcome

You will want to double check the data within the column then. The formula specifies to count anything that is

Not Blank

AND

Less Than Seven