I used 2 arguments for illustrative purposes.

Biff

"RagDyer" wrote in message
...
This does the same thing Biff:

=Sum((A1,A2,A3, ... A99,A100))

Considering that they weren't contiguous.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Biff" wrote in message
...
You're welcome. Thanks for the feedback!

Biff

"Martin" wrote in message
...
THANK YOU! It worked

"Biff" wrote:

You can use multiple area references:

=SUM((A1,A10,B2,C27,D40),(F28,G11,D12,AA2,L1))

The SUM function can use up to 30 arguments. In the above example there
are
2 arguments. Each set of references in ( ) is 1 argument.

Biff

"Martin" wrote in message
...
How can I get more that 30 random cells to total up? I have about 40
cells
I'd like totaled up which is over the limit. What I've done was split
my
report, total each half, then total the two halves.

Any advice?