View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

Hi!

For numeric numbers:

=COUNT(A1:C10)

For text:

=COUNTIF(A1:C10,"*")

Biff

-----Original Message-----
Is there a function that will give a count of the number

of cells in a range
that are occupied by a numeric value? Same question

again but occupied by a
text value.

TIA for any assistance
Sam Beardsley
.