How to count all cells within a column, that is, those containing characters AND blanks

[seanpod]

As the title says, how do I count all cells in a column, regardless of what the cell contains (character value or not).

I understand I could just take the difference of where the column ends and starts, but since many of the columns are starting halfway down a spreadsheet it'd be easier to use a formula.

Thanks.

[bhenlee]

Try:

=COUNTA(range) ex: =COUNTA(A:A)

count all cells that are not empty in column A

[Jacc]

Something like this:

Please Login or Register  to view this content.

[seanpod]

Something like this:

Please Login or Register  to view this content.

Great, thank you, works wonderfully.

Is there any way of getting around counting two or more merged cells as a single cell (which this formula does)?

Thanks!

[Jacc]

Good to hear it works!

Uh... Merged cells are almost tabu here because they just cause trouble. I'm pretty sure it can't be done with formulas but with a UDF it may be possible.