For starters, I know how to do a standard =SUM.
what I am looking for is to get the sum of the last 12 cells in a row based on the furthest filled cell to the right.
for example - Jessica - the last cell filled is K2, so I would want all cells from K2 and left 12 cells to be summed. (I want this one to stop at B2)
Matt, I would want cells Z3 to sum the previous 12 cells in that row. so Z3 through O3.
The issue I am having is that I want to sum to change when I add a value in that row. So now if I add a number in cell AE2, Jessica's totals would now change because AE2 and 12 rows to the left would be a different value.
I hope this makes sense to those of you that are going to try to help me.
Thanks in advance,
Bookmarks