counting non-empty rows in a column

F

Fede Querio

I'd like to calculate the number of non-empty cells contained in a specific
column, how can I do it?
Thanks,
Federico
 
A

Arvi Laanemets

I'd like to calculate the number of non-empty cells contained in a specific
column, how can I do it?
Thanks,
Federico
Click to expand...


Hi

=COUNTIF(A:A."<>")

This leavs out cells with functions returning nothing, like
IF(condition,value,""), also
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Quickly count used rows? 5
Remove Identical words 0
End of rows in a column 1
Macro for Append to csv 1
Simple code to find the empty cells in a range and cells with number 2
all above entered first 1
Need Help with a VBA subroutine 0

Top