Rolling figure to a cell

[Brenton]

I am trying to calculate a rolling figure to a cell by updating a spread
sheet on a weekly basis. I want to input data on a dated row and get the
formula to take this away from the previous dated reading and calculate to a
single cell.

 

[Ashish Mathur]

Hi,

Your question is not clear. Please post an example as well

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Brenton]

Date Previous week This week
Hours Set #1 2940 2940

Set #2 1936 2049

Set #3 2082 2130

Set #4 1908 1976

Kw Set #1 1361.762 1361.765

Set #2 1930.406 2019.982

Set #3 2085.238 2124.608

Set #4 1849.138 1901.259

Aux Set #1 26.188 26.191

Set #2 42.732 44.997

Set #3 46.057 47.037

Set #4 36.807 37.702

Fuel Set #1 340.899 340.937

Set #2 485.473 508.251

Set #3 520.235 530.011

Set #4 465.814 479.745

Hours
Set#1 0
Set#2 113
Set#3 48
Set#4 68