Do not count blank cells in the COUNTIF formula.

A simple =COUNTIF(G,"<>") works if the cells are blank. The "G" reference ignores headers and footers.

(edited to delete the incorrect additional info I provided. In your original formula using <>0, a blank cell is <>0 so it counted all of them)

If you have a column formatted as Number and you just want to count the number of values in that column, you can try something as simple as this:

Note that the last row is defined as a Footer Row so you can have a formula that refers to the whole column. That way you can add new data and the formula will automatically include the new rows so you don't have to edit the range in the formula.

If you have formulas in the column that show a "blank" that you don't want to count then you can try something like this:

=COUNTIF(G,"<>"&"")

Use ; instead of , in the formula if your regions uses , as the decimal separator.

SG

I don't know if anyone has noticed the difference between COUNTA(G) and COUNTIFS(G, "<>").

COUNTA counts cells that have a formula, even if the result is "".

COUNTIFS works on the value only, so it doesn't count a cell that has "" as the result of a formula.

COUNTBLANK works on the value too.

=COUNTIF(G,"<>"&"") is three characters longer than =COUNTIF(G,"<>") but shows better that you are comparing to the "" empty string, not including any formulas in the column.

=COUNTIF(G,REGEX(".")) gives the same result, with the regex matching any character in the cell.

SG

Use function COUNTA

chadb427 wrote:

=COUNTIF(G,"<>"&"") to count all the items in Column G, and if there is zero or no data in a cell, the formula will not count them, correct?

Recommend actually trying out the suggestions and other things.

I think you statement is almost correct.

=COUNTIF(G,"<>"&"") and COUNTA will exclude cells that don't have a value in them but will count cells that have 0 or a formula in them.

It would help if you could describe your use case.

SG