averaging months

PMRetired2012

New Member
Joined
Aug 6, 2019
Messages
45
what i want to do is.
i want a foumula that will let me to get a rolling average for a month as i add numbers for each week. that total will be in one cell. I want it to be able for it to figure a average for week 1,2,3,4 so that I will have a current average each week.
Example:

week 1 attendance 20
week 2 atten 45 20 + 45= 65...65/2= 33 adverage so far for month
week 3 attendence 25 20+45+75=..140/3=46 adverage so far for month
week 4 attendence 95 20+45+25+95=180/4=180/4 = 46.25 adverage for the whole month.
So another words i need a formula that keeps a running total for each week till we get to week 4 and that represents the total monthly total for that month

Thanks
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

RasGhul

Well-known Member
Joined
Jul 15, 2016
Messages
609
Hi,

Maybe this?

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="font-weight: bold;;">Week #</td><td style="font-weight: bold;;">Attendance</td><td style="font-weight: bold;text-align: right;;">r-AVG</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">Week1</td><td style="text-align: right;;">20</td><td style="text-align: right;;">20</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">Week2</td><td style="text-align: right;;">45</td><td style="text-align: right;;">32.5</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">Week3</td><td style="text-align: right;;">25</td><td style="text-align: right;;">30</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">Week4</td><td style="text-align: right;;">95</td><td style="text-align: right;;">46.25</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">C2</th><td style="text-align:left">=AVERAGE(<font color="Blue">$B$2:B2</font>)</td></tr></tbody></table></td></tr></table><br />
 
Last edited:

Forum statistics

Threads
1,089,622
Messages
5,409,381
Members
403,260
Latest member
ssauk

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top