Sum

M

Martin

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

Biff

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
 
M

Martin

THANK YOU! It worked

Biff said:
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
Click to expand...
 
R

RagDyer

This does the same thing Biff:

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

Considering that they weren't contiguous.
 
Top