(Msg. 1) Posted: Wed Aug 06, 2008 4:48 pm
Post subject: Counting numbers in an array Add to elertz Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
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
(Msg. 2) Posted: Wed Aug 06, 2008 4:48 pm
Post subject: Re: Counting numbers in an array Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
BRob wrote:
> 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
>
>
(Msg. 3) Posted: Wed Aug 06, 2008 4:48 pm
Post subject: RE: Counting numbers in an array Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
=SUMPRODUCT(--(ISNUMBER(A1:P30)))
"BRob" wrote:
> 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
>
>
>
(Msg. 4) Posted: Wed Aug 06, 2008 4:48 pm
Post subject: Re: Counting numbers in an array Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Try this:
=COUNT(A1:AD16)
--
Biff
Microsoft Excel MVP
"BRob" <del**eteto-hash#rfj1001@ntlworld.com> wrote in message
news:RIjmk.182918$x66.51186@newsfe25.ams2...
>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
>
(Msg. 5) Posted: Wed Aug 06, 2008 4:48 pm
Post subject: Re: Counting numbers in an array Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Wed, 6 Aug 2008 16:48:03 +0100, "BRob"
<del**eteto-hash#rfj1001@ntlworld.com> wrote:
>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
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office