Summing cells in every 14th row

[t2true]

I need to be able to add up the value of a cell in every 14th row.
The spreadsheet contains the results from a daily report (30 days worth). Each report is 14 rows. I need to add the results of one line for each report.
In other words I need to add cells I1, I15, I29, I43, I57; and then I2, I16, 130, I44, I58, etc.

Can someone provide feedback?

Thanks

[Duke Carey]

To get the first set:

=SUMPRODUCT(I1:I1000,--(MOD(ROW(I1:I1000),14)=1))

To get the second set:

=SUMPRODUCT(I1:I1000,--(MOD(ROW(I1:I1000),14)=2))

and so on


"t2true" wrote:

>
> I need to be able to add up the value of a cell in every 14th row.
> The spreadsheet contains the results from a daily report (30 days
> worth). Each report is 14 rows. I need to add the results of one line
> for each report.
> In other words I need to add cells I1, I15, I29, I43, I57; and then I2,
> I16, 130, I44, I58, etc.
>
> Can someone provide feedback?
>
> Thanks
>
>
> --
> t2true
> ------------------------------------------------------------------------
> t2true's Profile: http://www.excelforum.com/member.php...fo&userid=3877
> View this thread: http://www.excelforum.com/showthread...hreadid=387143
>
>

[bj]

there are multiple ways to do it.
one is to use Sumproduct
=sumproduct(--(mod(Row(I1:I1000),14)=1),I1:I1000) starting at row one
=sumproduct(--(mod(Row(I1:I1000),14)=2),I1:I1000) starting at row two
etc.

"t2true" wrote:

>
> I need to be able to add up the value of a cell in every 14th row.
> The spreadsheet contains the results from a daily report (30 days
> worth). Each report is 14 rows. I need to add the results of one line
> for each report.
> In other words I need to add cells I1, I15, I29, I43, I57; and then I2,
> I16, 130, I44, I58, etc.
>
> Can someone provide feedback?
>
> Thanks
>
>
> --
> t2true
> ------------------------------------------------------------------------
> t2true's Profile: http://www.excelforum.com/member.php...fo&userid=3877
> View this thread: http://www.excelforum.com/showthread...hreadid=387143
>
>