# weekly average

2. ### 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. ### 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. ### 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. ### 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...

### 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.

### Which adblocker are you using?

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

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