Thanks to all: Bernard, Pete, Biff & Billy for the valuable tips.

You gave me enough inspiration to solve my issue.

Wkr,

JP

"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