| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Too few arguments | Excel Worksheet Functions | |||
| too many arguments in formula. alternative? | Excel Discussion (Misc queries) | |||
| Help crating a formula with various arguments | Excel Worksheet Functions | |||
| how do I set up a formula using number ranges as the arguments | New Users to Excel | |||
| Are there too many arguments | Excel Worksheet Functions | |||
Linear Mode
