Question Locked

EXCEL FORMULA QUESTION NEED HELP ASAP!!

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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")

NEED HELP ASAP

2 replies

by thumbsup2

If by 'criteria' you mean that it's conditional upon what is in the cell you're looking at, then try using the Conditional Sum Wizard. It creates an IF statement.

This discussion is closed to new replies.