Counting numbers in an array

[BRob]

I want to count the number of cells in an array (16x30) that contain a
number rather than an alpha character.

Is there an easier way than do 16 column calculations and adding them all up

Tx

 

[Glenn]

I want to count the number of cells in an array (16x30) that contain a
number rather than an alpha character.

Is there an easier way than do 16 column calculations and adding them all up

Tx

=SUM(IF(ISNUMBER(A130),1,0))

(ctrl-shift-enter)

 

[Stephen Lloyd]

=SUMPRODUCT(--(ISNUMBER(A130)))

 

[T. Valko]

Try this:

=COUNT(A1:AD16)

 

[Ron Rosenfeld]

I want to count the number of cells in an array (16x30) that contain a
number rather than an alpha character.

Is there an easier way than do 16 column calculations and adding them all up

Tx

The COUNT function will count cells that contain only numbers, so might do what
you want, provided the cells are not formatted as text, or also contain text.

Can the cells that contain numbers also contain text, and, if so, do you want
to count them, too?
--ron