counting

  • Thread starter help with excel
  • Start date
H

help with excel

when i put in figures into cells and want to count how many there are how do
i do this. for example: 1;2;3;4;5;6;7 would be there are 7 at the end of the
cell.

thanks.
 
B

Bernard Liengme

=COUNT(A1:A7) for numbers
=COUNTA(A1:A7) for all entries (numbers, dates, text, etc)
best wishes
 

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

How to count the numbers in a Word document? 0
Section and Page numbering 0
I screwed up 0
Remove Identical words 0
Trying to create custom labels from an csv file + Need items numerically counted out 0
Nested if then statement 2
Count in a range of numbers 9
WORD VBA Search and switch to advanced ... 1

Top