Hi All...anybody got any examples of this. I have used one previously, looking for any more useful examples
Named Range called 'SUMBEFORE' with the formula :
You can write numbers all over the grid, then in the bottom right corner write =SUMBEFORE and will sum all items in the catchment using current cell as the anchor
Named Range called 'SUMBEFORE' with the formula :
Code:
=SUM(Sheet1!$A$1:OFFSET(Sheet1!$A$1,ROW()-2,COLUMN()-2))You can write numbers all over the grid, then in the bottom right corner write =SUMBEFORE and will sum all items in the catchment using current cell as the anchor
