Hi,
I'm using the below formula - the outcome should be that if all N/A - then ignore, if all Yes then then 0 and if any No then count number of Nos. However it's working in the other cells but some cells are merged and it's not working, please can someone guide me on this.
=IF(IF(COUNTIF(F32:T32,"N/A")=COUNTA(F32:T32)+COUNTBLANK(F32:T32),1,0)=1,"",IF(COUNTBLANK(F32:T32)>0,"",COUNTIF(F32:T32,"No")))
Many thanks
Bookmarks