Counting the cells in a column with data

[LaserDance]

Hi folks,

I have a long column with many empty cells, but some of them contain data. I need a formula which can count ONLY that cells which contain data. Any help ?

Thank you

[NBVC]

Have a look at the COUNTA() function.

[LaserDance]

Fine, but counta function counts also the empty cells. I do not need them and I do not know how to combine that fuction with another, probably isblank or something like that.

[NBVC]

The definition of COUNTA function:

The COUNTA function counts the number of cells that are not empty in a range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.).

So are your cells truly empty or null results from formulas? If so, perhaps:

=COUNTIF(A1:A100,"?*")

or

=ROWS(A1:A100)-COUNTBLANK(A1:A100)