Summing cells in every 14th row

  • Thread starter Thread starter t2true
  • Start date Start date
T

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 day
worth). Each report is 14 rows. I need to add the results of one lin
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?

Thank
 
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
 
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.
 
Back
Top