Hi,

Put this in B5 and drag down

=SUM(A1:A4)

Mike

"Brown" wrote:

I want to create a list of numbers and continuously add up the previous four
numbers. For example if column A has the numbers 1-52, then in column B,
starting in the fifth row, I would like it to add the previous four numbers.
Since the numbers from column A can and will change, the formula in B should
change. The answer in column B will then be read by another worksheet, in
oder for it to be included in a SUMIF or IF type formula