Thread: combining weekday formula, average and going back 7 cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default combining weekday formula, average and going back 7 cells
Hi Craig,

Assuming your data is in column F:
put this in G7
=AVERAGE(F1:F7)
and drag down as far as is needed, the cell references
will update automatically as you drag down.

HTH
Martin


Reply With QuoteReply With Quote