Hi experts,
I'm looking for a guidance regarding the below formula - currently it counts how many incorrects are there however what I want is : Between E30:M30 - however many incorrects selected take one off so for example if 8 columns selected as incorrect than it should show 7. However, if all of them showing as correct than it should show 0 (zero).
Many thanks,
I'm looking for a guidance regarding the below formula - currently it counts how many incorrects are there however what I want is : Between E30:M30 - however many incorrects selected take one off so for example if 8 columns selected as incorrect than it should show 7. However, if all of them showing as correct than it should show 0 (zero).
VBA Code:
=IF(IF(COUNTIF(E30:M30,"N/A")=COUNTA(E30:M30)+COUNTBLANK(E30:M30),1,0)=1,"",IF(COUNTBLANK(E30:M30)>0,"",COUNTIF(E30:M30,"Incorrect")))
Many thanks,