How do I add more than 30 arguments in a formula

W

wilsocm

I am trying to calculate various cells, not in a certain range, but it only
allows me to enter 30. Is there another function to calculate more than 30?
 
P

Peo Sjoblom

What's the formula?

just add another parenthesis and do another 30 and then another
=SUM((A1,A3,A5,A7,A9,A14,C19,D19,D12,E26,B29,E22,F16,C15,A18,A23,A27,A33,B36,C37,C35,D33,F30,E38,B40,F38,F40,H34,I30,I13,I18,K21,K24,K28,K19,G11,G17,I19,I13,G9,E12,F22,K25,and
so on))
 
R

Ron Rosenfeld

I am trying to calculate various cells, not in a certain range, but it only
allows me to enter 30. Is there another function to calculate more than 30?
Click to expand...

Instead of the SUM function, use the '+' operator (or some combination)
e.g.

=A1+B2+SUM(C3:C6)+D4+AA16...


--ron
 
W

wilsocm

=SUM(D300,D298,D296,D294,D292,D290,D288,D286,D284,D282,D280,D278,D276,D274,D272,D270,D268,D266,D264,D262,D260,D258,D256,D254,D252,D250,D248,D246,D244,D242))D240,D238,D236,D234,D232,D230,D228,D226,D224,D222)
is this what you mean
=SUM(D300,D298,D296,D294,D292,D290,D288,D286,D284,D282,D280,D278,D276,D274,D272,D270,D268,D266,D264,D262,D260,D258,D256,D254,D252,D250,D248,D246,D244,D242))D240,D238,D236,D234,D232,D230,D228,D226,D224,D222)(=SUM(D300,D298,D296,D294,D292,D290,D288,D286,D284,D282,D280,D278,D276,D274,D272,D270,D268,D266,D264,D262,D260,D258,D256,D254,D252,D250,D248,D246,D244,D242))D240,D238,D236,D234,D232,D230,D228,D226,D224,D222)
???
 
P

Peo Sjoblom

No, you can use

=SUM((D300,D298,D296,D294,D292,D290,D288,D286,D284,D282,D280,D278,D276,D274,D272,D270,D268,D266,D264,D262,D260,D258,D256,D254,D252,D250,D248,D246,D244,D242,D240,D238,D236,D234,D232,D230,D228,D226,D224,D222,D300,D298,D296,D294,D292,D290,D288,D286,D284,D282,D280,D278,D276,D274,D272,D270,D268,D266,D264,D262,D260,D258,D256,D254,D252,D250,D248,D246,D244,D242,D240,D238,D236,D234,D232,D230,D228,D226,D224,D222))





just add an extra parenthesis at the start and at the end for each set of 30
expressions


But it seems that you want to sum every other cell? If that is correct you
can use

=SUMPRODUCT(--(MOD(ROW(D2:D300),2)=0),D2:D300)


which will sum D2, D4, D6 and so on up to D300
 
T

T. Valko

Since your cells follow a pattern:

=SUMPRODUCT(--(MOD(ROW(D222:D230)-ROW(D222),2)=0),D222:D230)
 
Top