Summing cells in every 14th row

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
 
G

Guest

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Perfect Macro Combinations 5
I need some changes in a code 5
Handle a value from a Range instead of value of a Cell 8
Formula Too Long 8
Finding the greatest value 4
Inserting a fixed value in to hundereds of cells 2
Formula for counting number of blank cells in spreadsheet by row 1
Excel 2003 - VBA - Charts 1

Top