I have multiple columns and at the end of each one I have a SUM and MEAN lines.
Now I want to ignore some lines thus making
=SUM(A1:A13;A15) if I want to ignore line 14. Doing this for each formula is a tedious task.
In my previous question I found out how to do it for a single column. I would place the
A1:A15 string in a separate cell, then reference it using
INDIRECT. This way I can alter a single cell and update every formula for that column.
The problem is that I have multiple columns, with this approach I would have to update the
B1:B15 cell for each column. How to simplify this update process?