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:A15)
into =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?