I’d like to be able to
- specify columns by saying “Starting on column D, I want every third column”
- make these show up in one “total” column
The image probably describes it a little better – instead of doing ={Range1; Range2; Range 3; ...} manually for each desired range, a formula to do what I have described would make more sense.
In the example there are two axis but I don’t mind having to +1 the formula for the other column, my main concern is the “selecting every nth and adding up” part
