Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 16th 07, 08:50 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 3
Default how do i calculate a 4 week rolling average

How do i get excel to calculate and display a 4 week rolling average? I have
the dates of each week in column A, the sales data is entered in column B. I
am not sure if I need to use Today's date to generate the average or if I can
just get Excel to drop the 1st week when I enter a new sales figure. If
anyone has an understandable formula it would be most appreciated!

  #2   Report Post  
Old October 16th 07, 09:14 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 427
Default how do i calculate a 4 week rolling average

You said each row contains a total of sales data for the week, and
resides in column B. Assuming your first entry starts on row 1, to get
a 4-week rolling average you could simply use this formula in C4:
=SUM(B1:B4)/4
When you copy and paste that to the next row, the cell references will
shift, and consider only those 4 weeks of data.

Does that do what you need it to do?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I setup a rolling 13 week spreadsheet? cshel Excel Worksheet Functions 1 April 15th 07 03:16 AM
help with 12 week rolling average [email protected] Excel Worksheet Functions 3 January 29th 07 12:34 PM
Rolling 12 week calculations Throwme A Frigginbone Excel Worksheet Functions 2 January 9th 07 09:37 AM
Create a rolling 12 week graph Sheila Charts and Charting in Excel 2 October 13th 06 03:49 AM
Calculation using rolling 4 week amounts Janet T Excel Discussion (Misc queries) 3 November 15th 05 09:16 PM


All times are GMT +1. The time now is 12:22 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017