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?