I have 5 AVERAGEIFS formuals, one for each employee that work fine. I have trouble nesting the 5 employees into one formula. When I add the additional employees to the formula I get a result of #DIV/0!.
The 5 Average
=IFERROR(AVERAGEIFS('Jan2015'!$Z:$Z,'Jan2015'!$T:$T,"Transfer",'Jan2015'!$R:$R,"Employee1"),"")
=IFERROR(AVERAGEIFS('Jan2015'!$Z:$Z,'Jan2015'!$T:$T,"Transfer",'Jan2015'!$R:$R,"Employee2"),"")
=IFERROR(AVERAGEIFS('Jan2015'!$Z:$Z,'Jan2015'!$T:$T,"Transfer",'Jan2015'!$R:$R,"Employee3"),"")
=IFERROR(AVERAGEIFS('Jan2015'!$Z:$Z,'Jan2015'!$T:$T,"Transfer",'Jan2015'!$R:$R,"Employee4"),"")
=IFERROR(AVERAGEIFS('Jan2015'!$Z:$Z,'Jan2015'!$T:$T,"Transfer",'Jan2015'!$R:$R,"Employee5"),"")
Thanks for any help.
Bookmarks