Thread: Averaging
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kip Kip is offline
external usenet poster
 
Posts: 13
Default Averaging

I have a worksheet where I want to keep a 26 week running average even when I
add a cell into the middle of the range. I want the formula to lock in on the
first 26 items and only average the first 26 items in the array of values
--
Kip