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?

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?

=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?

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?

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?

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