Hi,I'm trying to count number of characters across few cells and I can't do it.I have entered :
=SUMPRODUCT(LEN(B3:B14)-LEN(SUBSTITUTE(B3:B14,"N","L","E"))) to check number of N,L,E because I will need them later to create IF formula.Please help.
I forget to add that above formula did not work
=SUMPRODUCT(LEN(B3:B14)-LEN(SUBSTITUTE(B3:B14,"N","L","E"))) to check number of N,L,E because I will need them later to create IF formula.Please help.
I forget to add that above formula did not work