Formula for calculating the last four weeks

H

Huber57

I have a spread sheet that has columns that each represent a week of the
year. I would like to create a formula that tallies the last four weeks that
are poplated so each time I add data for the week it will retrieve the new
data.

Is that possible? Do you need more detail? I am stumped.

Thanks!
 
G

Gary''s Student

Most beginners structure the columns with column A as the first week, column
B as the second week, etc....adding a column as the weeks go by.


Consider inserting a new column each week. Then column A will always be the
most current column, column B will be last week's column, etc. Therefore the
sum of the 4 most recent items might look like:

=A1+B1+C1+D1
 
Top