increasing arguments

  • Thread starter Thread starter kilroy
  • Start date Start date
K

kilroy

I'm performing a simple addition calculation for material that is neste
within other data, therefore i am unable to simpley sum the entir
column........

Currently its telling me i have too many arguments.........

=SUM(N146,N142,N138,N134,N130,N126,N122,N118,N114,N110,N106,N102,N98,N94,N90,N86,N82,N78,N74,N70,N66,N62,N58,N54,N50,N46,N42,N38,N34,N30,N26,N22)

that is a total of 32 cells notated.......how can i increase th
argument level from 30 to 32 or 33 ? Your assistance is greatl
appreciated
 
Most argument lists are limited to 30 arguments. You could break
them down:

=SUM(SUM(N146,N142,N138,N134,N130,N126,N122,N118,N114,N110),
SUM(N106,N102,N98,N94,N90,N86,N82,N78,N74,N70,N66,N62,N58),
SUM(N54,N50,N46,N42,N38,N34,N30,N26,N22 ))

or you could use something like:

=SUMPRODUCT(N22:N146,--(MOD(ROW(N22:N146),4)=2))
 
Back
Top