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

Do it like this:

=3DSUM(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

are
ut
it
e

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

Yes, of course, David - thanks.

Pete

up

Or even just:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

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