Good day,
I am getting the dreaded #DIV!/0 error, which is being produced by the 2nd set of COUNTIFS below. I handled the first #DIV!/0 error possibility from the first set of COUNTIFS. What is it I am doing wrong. I have spent hours trying to display a blank cell instead of the #DIV!/0 error.
=IF(ISERROR(COUNTIFS('Individual Progress'!$A:$A,Manager!$A15,'Individual Progress'!AP:AP,"100%")+COUNTIFS('Individual Progress'!$B:$B,Manager!$A15,'Individual Progress'!AP:AP,"100%")+COUNTIFS('Individual Progress'!$C:$C,Manager!$A15,'Individual Progress'!AP:AP,"100%")+COUNTIFS('Individual Progress'!$D:$D,Manager!$A15,'Individual Progress'!AP:AP,"100%")/$B$5),"", (COUNTIFS('Individual Progress'!$A:$A,Manager!$A15,'Individual Progress'!AQ:AQ,"100%")+COUNTIFS('Individual Progress'!$B:$B,Manager!$A15,'Individual Progress'!AQ:AQ,"100%")+COUNTIFS('Individual Progress'!$C:$C,Manager!$A15,'Individual Progress'!AQ:AQ,"100%")+COUNTIFS('Individual Progress'!$D:$D,Manager!$A15,'Individual Progress'!AQ:AQ,"100%"))/$B15)
Bookmarks