Thread: Problem with formula: need rolling average of 10 months
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Problem with formula: need rolling average of 10 months
in C11 put in the formula

=if(B11<"",Average(B2:B11),"")

then drag fill that down the column

--
Regards,
Tom Ogilvy


"Claire G" wrote in message
om...
Months are listed in ColumnA A2-A22
Data is listed in ColumnB B2-B22

Which formula would provide a running average of the past 10 months
(Nov-Aug)B13-B22. I would want this to update automatically next month
after adding a row for Dec-Sept B14-B23

Please help.


Reply With QuoteReply With Quote