Add total number of rows (text) in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a document that has entries consisting of text, numbers and dates in
separate columns. I would like to add the number of entries and don't mind
which column I am totalling. There are no conditions. I need to have the
total number of entries noted at the end of the document rather than having
the total number of lines used as a separate column.
Many thanks.
 
Hi!

So, you want to count how many cells have entries on the entire sheet?

=COUNTA(range)

Biff
 
You must log in or register to reply here.

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

text to column 1
Excel Subtracting multiple columns from another column 3
complex sort search and replace macro 2
Adding variable number of columns 8
Macro to add numbers in a text string 5
Summing cells containing dates 4
counting >=100% 4
Getting Count Formula Working if Column has both number and text 1

Back
Top