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?

Have you considered using a macro?

"Martin" wrote:

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?

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?

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?

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?

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?

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?