hello
can i change this code so that if there is an error it changes it to somthing like this code
=IF(ISERROR($G$17/$H$17),"- - -",$G$17/$H$17)
thanks jason
can i change this code so that if there is an error it changes it to somthing like this code
=IF(ISERROR($G$17/$H$17),"- - -",$G$17/$H$17)
thanks jason
Code:
=SUMPRODUCT(--($E$31:$E$475="MABF")*($O$31:$O$475="RED"),$H$31:$H$475)