| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
| Sum Cell Values of one column based on Another Cell Value in a different column | Excel Worksheet Functions | |||
| how to remove every seventh column from excel | Excel Discussion (Misc queries) | |||
| How do I delete every seventh row? | Excel Worksheet Functions | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
Linear Mode
