Counting any data in a column

**whatsmyname** · 08-02-2010, 12:54 PM

Hello everyone,

Hope all is well.

Is there a formula that I can put into a cell that will look at say Column H. and then it will count any cells in that column that contain any value at all (just not a blank cell) and total them?

Thank you all in advance!

**DonkeyOte** · 08-02-2010, 12:56 PM

see COUNTA though note we're assuming by blanks you mean cells entirely devoid of content and not Formula Nulls... else you will need to use a slightly different approach.

**whatsmyname** · 08-02-2010, 01:56 PM

Originally Posted by DonkeyOte

see COUNTA though note we're assuming by blanks you mean cells entirely devoid of content and not Formula Nulls... else you will need to use a slightly different approach.

Thank you DonkeyOte, I will look up that COUNTA formula. I'm kind of confused on your replay though. I'm not to sure what you meant by "COUNTA though note".

Any more detailed information would be great!

Thank you.