Hi Folks
Can anyone point in the direction of where I'm not quite getting this formulae correct please?
I'm trying to get it to count instances of the word "No" in a range. However the word "No" may be in lower or upper case and be part of a string as in: "No - already notified"
=SUMPRODUCT((LEN(G14:G38)-LEN(SUBSTITUTE((UPPER(G14:G38,"No","")),UPPER("No"),"")))/LEN("No"))
Many thanks
DezB