Please help!

[collegeitdept]

Can someone please help me with this formula please?

It currently calculates monthly averages - I need it 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 ,10,11,12}),1))


Weekly data file:

https://dl.dropboxusercontent.com/u/...20average.xlsx

 

[RoryA]

Please do not keep posting the same question. If you do not get an answer to a thread you may bump it up (no more than once a day, please) or consider adding more information, or rephrasing it in case it isn't clear. I'm locking this thread now.