Well, if you could arrange that the cells you wanted to sum are the
same on each of those sheets (eg Z1, which may contain a formula to
pick up from the actual cell in each sheet), then you could have:

=SUM(first:last!Z1)

where first and last are the outer sheets of a "sandwich". There could
be more than 30 sheets in the sandwich.

Hope this helps.

Pete

On Sep 4, 4:49*pm, "JP Ronse" wrote:
Hi Bernard,

Of course, perhaps I was not clear enough.

In most cases 30 arguments will be more then enough because most of the
arguments can be written as a range.

But suppose I have a huge workbook with more then 30 sheets and I have to
sum a value from each sheet. Then I can't write it anymore as *range. I know
there are workarounds to get the result but was just looking fora way to
overrule the limitation when using cells just as you can do with values by
enclosure them with {}.

Wkr,

JP

"Bernard Liengme" wrote in message

...



The formula =SUM(A1:A10000) has only ONE argument
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"JP Ronse" wrote in message
...
Hi All,

A lot of functions have a limitation on the number of arguments/values,
e.g.

=SUM(cell_1, cell_2, ...., cell_30). (non-adjacent cells)

The same limitation exists if values are used:

=SUM(1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 ,1,1,1,1,1,1,1)

But you can overrule the limitation if you write the function as:

=SUM({1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1, 1,1,1,1,1,1,1,1,1,1,1,1,1*,1,1,1,1,1,1})
= 40

My question is if there is a way to write functions with ranges allowing
to overrule the limitation?

I've tried already something like =SUM({cell_1,cell_2}) but this doesn't
work.

Wkr,

JP- Hide quoted text -

- Show quoted text -