Counting numbers of numbers

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Help please!

I have a set of cells, some with numbers in. How can I get Excel to count
the number of numbers in the defined area?

Thanks

Mike
 
Mike,

Try

=SUMPRODUCT(--(ISNUMBER(A1:A100)))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

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

Red cell for negative numbers in Excel 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
need help on either doing a loop and counting specific values orusing subtotal function 2
Excel 2003 Counting multiple number entries in a single cell 6
count nonblank cells 3
Countif formula perhaps 7
Excel Need Countifs Formula Help 0
Counting the number of times a character occurs in a cell 1

Back
Top