cell totals

L

Lynn

Hi,
I have a spreadsheet that has data in Column A Rows 1, 4, 5, 7 & 9. The
data within rows 1, 4 & 5 are numbers the data within rows 7 & 9 are text.
Rows 2, 3, 6 & 8 are blank.
I want to count the total number of cells that have information in it
regardless of if it's text or numeric (of course not count the number of
blank cells) so the answer would be 5
is there a formula that can do that? does this make sense?

Thanks
Lynn
 

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

Arriving at totals 2
Page numbering with Merged Document and IF statements 1
Dealing with the error: unable to filter on excel hc home school 0
How to count the numbers in a Word document? 0
Finding the right style field in VBA 0
filter result- total row numbers varies 1
Finding the proper style field and the numbered paragraph value within the style 0
Paragraph numbering in Word 1

Top