How do I add more than 30 arguments in a formula
 

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?

How do I add more than 30 arguments in a formula
 

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,F 16,C15,A18,A23,A27,A33,B36,C37,C35,D33,F30,E38,B40 ,F38,F40,H34,I30,I13,I18,K21,K24,K28,K19,G11,G17,I 19,I13,G9,E12,F22,K25,and
so on))





--
Regards,

Peo Sjoblom

"wilsocm" wrote in message
...
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?

How do I add more than 30 arguments in a formula
 

On Wed, 18 Jul 2007 08:56:02 -0700, wilsocm
wrote:

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?

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

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


--ron

How do I add more than 30 arguments in a formula
 

=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,D28 6,D284,D282,D280,D278,D276,D274,D272,D270,D268,D26 6,D264,D262,D260,D258,D256,D254,D252,D250,D248,D24 6,D244,D242))D240,D238,D236,D234,D232,D230,D228,D2 26,D224,D222)
???
"Peo Sjoblom" wrote:

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,F 16,C15,A18,A23,A27,A33,B36,C37,C35,D33,F30,E38,B40 ,F38,F40,H34,I30,I13,I18,K21,K24,K28,K19,G11,G17,I 19,I13,G9,E12,F22,K25,and
so on))





--
Regards,

Peo Sjoblom

"wilsocm" wrote in message
...
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?

How do I add more than 30 arguments in a formula
 

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



--
Regards,

Peo Sjoblom



"wilsocm" wrote in message
...
=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,D28 6,D284,D282,D280,D278,D276,D274,D272,D270,D268,D26 6,D264,D262,D260,D258,D256,D254,D252,D250,D248,D24 6,D244,D242))D240,D238,D236,D234,D232,D230,D228,D2 26,D224,D222)
???
"Peo Sjoblom" wrote:

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,F 16,C15,A18,A23,A27,A33,B36,C37,C35,D33,F30,E38,B40 ,F38,F40,H34,I30,I13,I18,K21,K24,K28,K19,G11,G17,I 19,I13,G9,E12,F22,K25,and
so on))





--
Regards,

Peo Sjoblom

"wilsocm" wrote in message
...
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?

How do I add more than 30 arguments in a formula
 

Since your cells follow a pattern:

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

--
Biff
Microsoft Excel MVP


"wilsocm" wrote in message
...
=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,D28 6,D284,D282,D280,D278,D276,D274,D272,D270,D268,D26 6,D264,D262,D260,D258,D256,D254,D252,D250,D248,D24 6,D244,D242))D240,D238,D236,D234,D232,D230,D228,D2 26,D224,D222)
???
"Peo Sjoblom" wrote:

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,F 16,C15,A18,A23,A27,A33,B36,C37,C35,D33,F30,E38,B40 ,F38,F40,H34,I30,I13,I18,K21,K24,K28,K19,G11,G17,I 19,I13,G9,E12,F22,K25,and
so on))





--
Regards,

Peo Sjoblom

"wilsocm" wrote in message
...
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?