SUM & Average Formula Problem

[Miki]

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 ??????????

 

[Pete_UK]

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

 

[David Biddulph]

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

 

[Pete_UK]

Yes, of course, David - thanks.

Pete

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









- Show quoted text -

 

[RagDyer]

Or even just:

=Sum((list of as many cells as needed))

 

[Miki]

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

Or even just:

=Sum((list of as many cells as needed))