View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brown Brown is offline
external usenet poster
 
Posts: 2
Default How do I continuosly add from list

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