Sum every 3rd cell (more then 30 cells) 1

[KMerritt]

I have a Excel spreadsheet that I need to add and romove rows from month to month. I have a total at the bottom that sums every third row. I now have more then 30 rows, and can use the same formula. I thought about VBA to solve this problem, but person that maintains it does'nt know VBA, so I would have to maintain it when a line got changed. Is there a quick and easy way to sum every 3rd cell in a column?

 

[SkipVought]

Hi,

Sure - in each row use this formula (I put it in Col C)

=MOD(ROW(),3)

Name a cell on another sheet "RowOffset" with a value of either 0, 1 or 2 to select the row sets you want to sum.
Then wherever you want to SUM to be displayed, enter this formula...

=SUMIF(C2:C10,RowOffset,A2:A10)

Col C has the MOD formula and Col A has the values to sum - modify according to your data.

Hope this helps
Skip,
metzgsk@voughtaircraft.com

 

[KMerritt]

Thanks, it worked perfectly. Very creative