Say a column (say column A) has cells with the following values and I want to end up with the sum of the values between each marker in column B.The marker could be a text value or a colorindex but would always be the same. The numbers in column A vary and get put there by a macro and get deleted by a macro. The markers also come and go by macro. (The marker will actually represent a wall and the numbers will be door and window areas that need to be deducted from the wall area).
Is there a way to do this which does not involve problems with formulas not adjusting properly as lines are added or deleted?
A B
__________________
marker 14
4
7
3
marker 8
2
6
marker 12
8
1
3
marker
All help appreciated
Heimir.
Is there a way to do this which does not involve problems with formulas not adjusting properly as lines are added or deleted?
A B
__________________
marker 14
4
7
3
marker 8
2
6
marker 12
8
1
3
marker
All help appreciated
Heimir.