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!