Hi there,
Pl have a look at attached wb. I am trying to calculate shift wise weighted average. Pl suggest me how to calculate monthly average of shift 1 & shift 2 In col J8 & K8 respectively.
Average
-
HansV
- Administrator
- Posts: 78600
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Average
I'd change the formula in B8 to
=IF(ISERROR((AVERAGE(B3:B7))),"",(AVERAGE(B3:B7)))
and fill right to I8. If there are no data, the average shouldn't be 0 but blank.
Enter the following array formula in J8 (confirm with Ctrl+Shift+Enter):
=AVERAGE(IF($B$2:$I$2=J2,$B$8:$I$8))
and fill right to K8.
=IF(ISERROR((AVERAGE(B3:B7))),"",(AVERAGE(B3:B7)))
and fill right to I8. If there are no data, the average shouldn't be 0 but blank.
Enter the following array formula in J8 (confirm with Ctrl+Shift+Enter):
=AVERAGE(IF($B$2:$I$2=J2,$B$8:$I$8))
and fill right to K8.
Best wishes,
Hans
Hans
-
Prasad
- StarLounger
- Posts: 62
- Joined: 27 Jan 2010, 05:00
Re: Average
Perfect. Thank you very much Hans. 
Regards
Prasad
Encourage Environmental Awareness| Print only if unavoidable
Prasad
Encourage Environmental Awareness| Print only if unavoidable