I have a dynamic named range (called "myRange") that is currently in cells C3:C45. Each day, this range 'grows' by 1 row. So, tomorrow, for instance, the range will be from C3:C46. I am trying to write a formula that would SUM up the last 5 values in this range. So, simplistically, the formula would just be =SUM(C41:C45). BUT, how do I write a SUM formula that also grows with the range. So, a few weeks from now, the formula would maybe read =SUM(C92:C96).

Is there a way to make the formula 'move' automatically as the range grows with time?

Thanks a lot!

Rachel