How to calculate Weekly Average

[sapsurya]

Hi Every One,

Please help Me asap.

In RTSWeeklyReport-Data sheet there are 3 columns "TICKET","SPONG","Total" I need weekly average for these three columns it should look like Weekly average in sheet RTS-Report.

RTS-Report excel sheet I need to calculate **** Weekly Average **** , Week start from Sat and so on,
Example:- 1 March 2014 (Sat) to 7 March 2014.....So on

Please find the attachment also

[ratcat]

This help ?

[MarvinP]

Hi sapsurya and welcome to the forum,


See if a Pivot Table answer works for you. See the attached.

[sapsurya]

My Dear friends RATCAT & MARVINP, Thanks for your efforts and time, but this did not resolve my issue.
1] RATCAT in your sheet4 where will I add "Consultant" how will I come to know which consultant did what?

2] MarvinP yours is Sheet4 I hope it wrong.

Please compare your average with **** Weekly Average ****sheet I need =IFERROR(AVERAGE($G6:$M6),0) ------ Average every week sat to Sunday again Sat to Sunday.

Please find the fresh attachment RTS-CSC-Report (2).xlsx


Thanks in Advance,,,,, Please help request................