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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I get a sum of every seventh cell in a column? (https://www.excelbanter.com/excel-worksheet-functions/257393-how-do-i-get-sum-every-seventh-cell-column.html)

Jubilado

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

Hello I am trying to find out how to get a sum of cells with a specific fixed
interval between them

Bernard Liengme[_2_]

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

This will sum every seventh value in column A
=SUMPRODUCT(--(MOD(ROW(A1:A100),7)=1),A1:A100)
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Jubilado" wrote in message
...
Hello I am trying to find out how to get a sum of cells with a specific
fixed
interval between them

T. Valko

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

What is the range of cells you want to sum? A1:A100? A22:A559? A777:A22351?

--
Biff
Microsoft Excel MVP

"Jubilado" wrote in message
...
Hello I am trying to find out how to get a sum of cells with a specific
fixed
interval between them

All times are GMT +1. The time now is 09:47 AM.