I have a sheet with c1:f1 and h1:k1 with week 29 to week 36, the data for
these weeks are in c5:f5 and h5:k5, this is also with a running total, which
will show in chart form.My question is that suppose i have entered data for
week 29,30 and 31 what formula will show that the running total is through
week 31 and then when i input week 32 the total will show through week 32,
this is because the people inputing the data will not place a week number in
manually if i set it up that way.