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)
 
Back
Top