Extend the number of arguments of a function
You can combine two SUM Functions e.g.
=SUM(C1,C2,C3,C4,C5,C6,C7,C8,C9,C10,C11,C12,C13,C1 4,C15,C16,C17,C18,C19,C20)+SUM(D1,D2,D3,D4,D5,D6,D 7,D8,D9,D10,D11,D12,D13,D14,D15,D16,D17,D18,D19,D2 0)
40 Cells
HTH
Peter
"JP Ronse" wrote:
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
|