I have been wrestling with this for couple of hours now and was hoping to get pointed in the correct direction.
I have this formula in Excel 07 and of course works beautifully.
I've tried this but it's not factoring in the Yes....
Obviously, I can't use the 07 formula because no one else in the department has it. Any help is always greatly appreciated.
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.