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