I'm trying to get rid of the DIV/0 error that keeps popping up with this formula:
=(SUMIF(B2:B26,"YES",C2:C26))/((COUNTA(C2:C26)))
I've tried to add the ISERROR function and a couple other functions but I haven't had any luck. Anyone have any suggestions?
Bookmarks