Hi I am trying to calculate rolling average for attached data in row currently i am using formula =IFERROR(AVERAGEIFS(DM8:GZ8,$DM$1:$GZ$1,"Mon",DM8:GZ8,"<>0"),"") to calculate average however now want to calculate in rolling for previous 16 weeks as off today. Data will be uploaded on real time basis daily and want to calculate average of previous 16 weeks of Weekdays "Sun" , "Mon"....... Can anyone please help me ASAP. Attached is Excel file for your reference Password to open is "mis"
Hello AmitSharma,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Please help Me ASAPOriginally Posted by AmitSharma
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks