I have this formula in Excel 07 and of course works beautifully.

Code:

`=IFERROR(AVERAGEIF(March!$D$3:$D$10000,"Yes",March!$P$3:$P$10000),0)`

I've tried this but it's not factoring in the Yes....

Code:

`=IF(ISERROR(AVERAGE(IF(March!$D$3:$D$10000="Yes",AVERAGE(March!$P$3:$P$10000)))),0,AVERAGE(IF(March!$D$3:$D$10000="Yes",AVERAGE(March!$P$3:$P$10000))))`

Obviously, I can't use the 07 formula because no one else in the department has it. Any help is always greatly appreciated.