weekly average

  1. C

    Please help!

    Can someone please help me with this formula please? It currently calculates monthly averages - I need it calculate weekly averages...
  2. C

    Question: Sum product weekly averages?

    Can someone please help me modify this sum product average formula (currently for months) - to calculate weekly averages? =SUM(IF(FREQUENCY(IF((ROUNDUP(MONTH($A$2:$A$100)/3,0)=MID(AG$4,2,1)+0)*(YEAR($A$2:$A$100)=VALUE(RIGHT(AG$4,4)))*($C$2:$C$100=AG$5),MONTH($A$2:$A$100)),{1,2,3,4,5,6,7,8,9...
  3. C

    Modify sum average formula for weeks (instead of months)

    Thank you to Barry for your formula! It worked. One last question about the sumproduct average formula for months - how can this be modified for weekly averages...
  4. D

    Weekly and Monthly Averages from Daily Data

    I am trying to come up with formulas that will list the weekly dates based on the first date in the data table and compute corresponding weekly average. In this case, the first week must be the first full week in that month that starts on a Sunday. All other weeks must start on the subsequent...
  5. B

    Calculating weekly average of a dynamic named range or pivot table data

    Hello - I have a table that keeps records of requests (no null values). I would like to display the weekly average number of requests. Currently, I have a pivot table running with the table sourced, and I get have the following formula for referencing the average number of requests...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top