sum more than 5 cells

if sum more than 5 cells not in consecutive order, I can use the AutoSum and
select the cells I want using the control button or type in =SUM(C23,C34,c40,
c45, c50,c56,c63,...). However, I receive an error saying I have too many
arguments. Why is this displaying?

Because you have too many arguments.

XL functions are limited to 30 arguments.

One workaround: Select your cells and name them, say "sum_range" by
entering "sum_range" (without quotes) in the Name box at the left side
of the formula bar.

Then you can use one argument:

=SUM(sum_range)

In article <6D31B10F-51D9-4BDE-B47F-127FE724C86E@microsoft.com>,
kermit <kermit@discussions.microsoft.com> wrote:

> if sum more than 5 cells not in consecutive order, I can use the AutoSum and
> select the cells I want using the control button or type in =SUM(C23,C34,c40,
> c45, c50,c56,c63,...). However, I receive an error saying I have too many
> arguments. Why is this displaying?

Same problem, but I want to sum every 5th line (Multibles the of 30 max) from
spreadsheet imported from "Home Depot's WorkSite CD". None of the functions
came over, just the resultant values.

"JE McGimpsey" wrote:

> Because you have too many arguments.
>
> XL functions are limited to 30 arguments.
>
> One workaround: Select your cells and name them, say "sum_range" by
> entering "sum_range" (without quotes) in the Name box at the left side
> of the formula bar.
>
> Then you can use one argument:
>
> =SUM(sum_range)
>
> In article <6D31B10F-51D9-4BDE-B47F-127FE724C86E@microsoft.com>,
> kermit <kermit@discussions.microsoft.com> wrote:
>
> > if sum more than 5 cells not in consecutive order, I can use the AutoSum and
> > select the cells I want using the control button or type in =SUM(C23,C34,c40,
> > c45, c50,c56,c63,...). However, I receive an error saying I have too many
> > arguments. Why is this displaying?
>

Assuming you want to sum rows 1, 6, 11, etc

=SUMPRODUCT((MOD(ROW(A1:A100),5)=1)*(A1:A100))

To sum rows 5, 10, 15, etc, change =1 to =0

On Fri, 18 Feb 2005 19:41:01 -0800, "Buildourhouse"
<Buildourhouse@discussions.microsoft.com> wrote:

>Same problem, but I want to sum every 5th line (Multibles the of 30 max) from
>spreadsheet imported from "Home Depot's WorkSite CD". None of the functions
>came over, just the resultant values.
>
>"JE McGimpsey" wrote:
>
>> Because you have too many arguments.
>>
>> XL functions are limited to 30 arguments.
>>
>> One workaround: Select your cells and name them, say "sum_range" by
>> entering "sum_range" (without quotes) in the Name box at the left side
>> of the formula bar.
>>
>> Then you can use one argument:
>>
>> =SUM(sum_range)
>>
>> In article <6D31B10F-51D9-4BDE-B47F-127FE724C86E@microsoft.com>,
>> kermit <kermit@discussions.microsoft.com> wrote:
>>
>> > if sum more than 5 cells not in consecutive order, I can use the AutoSum
and
>> > select the cells I want using the control button or type in
=SUM(C23,C34,c40,
>> > c45, c50,c56,c63,...). However, I receive an error saying I have too
many
>> > arguments. Why is this displaying?
>>

Thank you, Myrna. This spreadsheet is a material list that repeats it's
format/layout every 5th line. Can I set up a sheet that will have functions
automatically duplicated every 5th line for each material entry? 1st line
blank.
Next 2 lines are just descriptions (text),
4th is (B-hourly rate) (C-hours) (E-material cost) (F-labor cost)
(G-equipment cost) (H-total unit cost).
5th line (A-# of units) (C,E,F,G,H as above * # of units).
These are then totaled at bottom (Previous question you answered)
thanks

"Myrna Larson" wrote:

> Assuming you want to sum rows 1, 6, 11, etc
>
> =SUMPRODUCT((MOD(ROW(A1:A100),5)=1)*(A1:A100))
>
> To sum rows 5, 10, 15, etc, change =1 to =0
>
> On Fri, 18 Feb 2005 19:41:01 -0800, "Buildourhouse"
> <Buildourhouse@discussions.microsoft.com> wrote:
>
> >Same problem, but I want to sum every 5th line (Multibles the of 30 max) from
> >spreadsheet imported from "Home Depot's WorkSite CD". None of the functions
> >came over, just the resultant values.
> >
> >"JE McGimpsey" wrote:
> >
> >> Because you have too many arguments.
> >>
> >> XL functions are limited to 30 arguments.
> >>
> >> One workaround: Select your cells and name them, say "sum_range" by
> >> entering "sum_range" (without quotes) in the Name box at the left side
> >> of the formula bar.
> >>
> >> Then you can use one argument:
> >>
> >> =SUM(sum_range)
> >>
> >> In article <6D31B10F-51D9-4BDE-B47F-127FE724C86E@microsoft.com>,
> >> kermit <kermit@discussions.microsoft.com> wrote:
> >>
> >> > if sum more than 5 cells not in consecutive order, I can use the AutoSum
> and
> >> > select the cells I want using the control button or type in
> =SUM(C23,C34,c40,
> >> > c45, c50,c56,c63,...). However, I receive an error saying I have too
> many
> >> > arguments. Why is this displaying?
> >>
>
>

Set up the first 5 rows as you want them (say rows 2:6). Then select all 5
rows and Edit/Copy. Then select a multiple of 5 rows below that (say 7:46 for
an additional 8 blocks) and Edit/Paste.

On Sun, 20 Feb 2005 00:07:02 -0800, "buildourhouse"
<buildourhouse@discussions.microsoft.com> wrote:

>Thank you, Myrna. This spreadsheet is a material list that repeats it's
>format/layout every 5th line. Can I set up a sheet that will have functions
>automatically duplicated every 5th line for each material entry? 1st line
>blank.
>Next 2 lines are just descriptions (text),
>4th is (B-hourly rate) (C-hours) (E-material cost) (F-labor cost)
>(G-equipment cost) (H-total unit cost).
>5th line (A-# of units) (C,E,F,G,H as above * # of units).
>These are then totaled at bottom (Previous question you answered)
>thanks
>
>"Myrna Larson" wrote:
>
>> Assuming you want to sum rows 1, 6, 11, etc
>>
>> =SUMPRODUCT((MOD(ROW(A1:A100),5)=1)*(A1:A100))
>>
>> To sum rows 5, 10, 15, etc, change =1 to =0
>>
>> On Fri, 18 Feb 2005 19:41:01 -0800, "Buildourhouse"
>> <Buildourhouse@discussions.microsoft.com> wrote:
>>
>> >Same problem, but I want to sum every 5th line (Multibles the of 30 max)
from
>> >spreadsheet imported from "Home Depot's WorkSite CD". None of the
functions
>> >came over, just the resultant values.
>> >
>> >"JE McGimpsey" wrote:
>> >
>> >> Because you have too many arguments.
>> >>
>> >> XL functions are limited to 30 arguments.
>> >>
>> >> One workaround: Select your cells and name them, say "sum_range" by
>> >> entering "sum_range" (without quotes) in the Name box at the left side
>> >> of the formula bar.
>> >>
>> >> Then you can use one argument:
>> >>
>> >> =SUM(sum_range)
>> >>
>> >> In article <6D31B10F-51D9-4BDE-B47F-127FE724C86E@microsoft.com>,
>> >> kermit <kermit@discussions.microsoft.com> wrote:
>> >>
>> >> > if sum more than 5 cells not in consecutive order, I can use the
AutoSum
>> and
>> >> > select the cells I want using the control button or type in
>> =SUM(C23,C34,c40,
>> >> > c45, c50,c56,c63,...). However, I receive an error saying I have too
>> many
>> >> > arguments. Why is this displaying?
>> >>
>>
>>