Sum

[Guest]

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?

 

[Guest]

Have you considered using a macro?

 

[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

 

[Guest]

THANK YOU! It worked

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

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

THANK YOU! It worked

 

[RagDyer]

This does the same thing Biff:

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

Considering that they weren't contiguous.

 

[Biff]

I used 2 arguments for illustrative purposes.

Biff