ExcelBanter - formula based on continuous relative cells

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula based on continuous relative cells (https://www.excelbanter.com/excel-discussion-misc-queries/257110-formula-based-continuous-relative-cells.html)

bwilde

formula based on continuous relative cells

I want formula where the value is the sum of the first cell i select plus
every 6th cell after it in the row and also minus every 5th cell in that row.

All times are GMT +1. The time now is 04:52 AM.