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