How do I get a sum of every seventh cell in a column?

  • Thread starter Thread starter Jubilado
  • Start date Start date
J

Jubilado

Hello I am trying to find out how to get a sum of cells with a specific fixed
interval between them
 
This will sum every seventh value in column A
=SUMPRODUCT(--(MOD(ROW(A1:A100),7)=1),A1:A100)
best wishes
 
What is the range of cells you want to sum? A1:A100? A22:A559? A777:A22351?
 
You must log in or register to reply here.

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

Help with formula 7
Sum Values from different column 1
sum of multiple rows 2
How can I copy the sum of a filtered column into a cell in anothe 1
How do I delete every seventh row? 3
Partial / Conditional Sum of a Column 11
Sum every 6th cell in a row. 3
How to sum one cell across workbook if nr of worksheets is variabl 2

Back
Top