SUM & Average Formula Problem
 

I want to sum up different cells around 40 in a single worksheet but they are
in different rows and columns and I can't select a range to add them up but
whenever I try to give different cell locations separating them by comma, it
stops after 30 cells.

Is there any way to sum or get average of more than 30 numbers in a single
worksheet ??????????

SUM & Average Formula Problem
 

Do it like this:

=SUM(list of up to 30 cells) + SUM(list of another 30 cells) + etc.

To get an average you can take the sum from above and divide it by the
COUNT of the number of cells.

Hope this helps.

Pete

On Aug 15, 7:48*am, Miki wrote:
I want to sum up different cells around 40 in a single worksheet but they are
in different rows and columns and I can't select a range to add them up but
whenever I try to give different cell locations separating them by comma, it
stops after 30 cells.

Is there any way to sum or get average of more than 30 numbers in a single
worksheet ??????????

SUM & Average Formula Problem
 

Or even just
=SUM((list of up to 30 cells),(list of another 30 cells),(etc...))
--
David Biddulph

"Pete_UK" wrote in message
...
Do it like this:

=SUM(list of up to 30 cells) + SUM(list of another 30 cells) + etc.

To get an average you can take the sum from above and divide it by the
COUNT of the number of cells.

Hope this helps.

Pete

On Aug 15, 7:48 am, Miki wrote:
I want to sum up different cells around 40 in a single worksheet but
they are
in different rows and columns and I can't select a range to add them up
but
whenever I try to give different cell locations separating them by
comma, it
stops after 30 cells.

Is there any way to sum or get average of more than 30 numbers in a
single
worksheet ??????????

SUM & Average Formula Problem
 

Yes, of course, David - thanks.

Pete

On Aug 15, 1:36*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Or even just
=SUM((list of up to 30 cells),(list of another 30 cells),(etc...))
--
David Biddulph

"Pete_UK" wrote in message

...



Do it like this:

=SUM(list of up to 30 cells) + SUM(list of another 30 cells) + etc.

To get an average you can take the sum from above and divide it by the
COUNT of the number of cells.

Hope this helps.

Pete

On Aug 15, 7:48 am, Miki wrote:
I want to sum up different cells around 40 in a single worksheet but
they are
in different rows and columns and I can't select a range to add them up
but
whenever I try to give different cell locations separating them by
comma, it
stops after 30 cells.

Is there any way to sum or get average of more than 30 numbers in a
single
worksheet ??????????- Hide quoted text -

- Show quoted text -

SUM & Average Formula Problem
 

Or even just:

=Sum((list of as many cells as needed))
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Or even just
=SUM((list of up to 30 cells),(list of another 30 cells),(etc...))
--
David Biddulph

"Pete_UK" wrote in message
...
Do it like this:

=SUM(list of up to 30 cells) + SUM(list of another 30 cells) + etc.

To get an average you can take the sum from above and divide it by the
COUNT of the number of cells.

Hope this helps.

Pete

On Aug 15, 7:48 am, Miki wrote:
I want to sum up different cells around 40 in a single worksheet but
they are
in different rows and columns and I can't select a range to add them up
but
whenever I try to give different cell locations separating them by
comma, it
stops after 30 cells.

Is there any way to sum or get average of more than 30 numbers in a
single
worksheet ??????????

SUM & Average Formula Problem
 

Thanx a ton ..........
It worked ........

"RagDyer" wrote:

Or even just:

=Sum((list of as many cells as needed))
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Or even just
=SUM((list of up to 30 cells),(list of another 30 cells),(etc...))
--
David Biddulph

"Pete_UK" wrote in message
...
Do it like this:

=SUM(list of up to 30 cells) + SUM(list of another 30 cells) + etc.

To get an average you can take the sum from above and divide it by the
COUNT of the number of cells.

Hope this helps.

Pete

On Aug 15, 7:48 am, Miki wrote:
I want to sum up different cells around 40 in a single worksheet but
they are
in different rows and columns and I can't select a range to add them up
but
whenever I try to give different cell locations separating them by
comma, it
stops after 30 cells.

Is there any way to sum or get average of more than 30 numbers in a
single
worksheet ??????????