EXCEL FORMULA QUESTION NEED HELP ASAP!!

by cemcqueen . Updated 16 years, 3 months ago

This formula is a CSE formula it’s doing the first part of what I want it to do, now I want to add a second criteria to this formula from a different column

=SUM(LEN(A2:A15)-LEN(SUBSTITUTE(A2:A15,”text”,””)))/LEN(“text”)