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