Complicated Average Formula Help

[Ecel Dumbo]

HI Friends,
Could you please refer the attached Document and kindly suggest formulas for different types of averages ?
I have asked this another forum as well.
http://www.excelforum.com/excel-general/1065072-complicated-average-formula-help.html

Excel Dumbo

 

[Nebu]

Hi:

Sheet 1 will answer your all questions.

Thanks

 

[Ecel Dumbo]

Hi Nebu,

Thank you very much for doing this. Before I get my head around this completely, could you please tell me the trick of how your made the dates apaear as months (Jan, Feb,Mar) as shown in the sheet 1 of pivot table ?

 

[Ecel Dumbo]

I got it nebu. The solution was there in Chandoo itself. Thank you

http://chandoo.org/wp/2009/11/17/group-dates-in-pivot-tables/

 

[Ecel Dumbo]

HI Nebu. THank you very much. This served my purpose