View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Billy Liddel Billy Liddel is offline
external usenet poster
 
Posts: 527
Default 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