Excel Forum

Excel Magic Trick 291: Add Nums Associated w Codes From String

See how to count and then add values associated with codes from a column of text strings. For example: If we are counting PCP in this list: {"PCP, TP, N, N, PA";"N, N, PA";"PCP, N, PA";"TP, N, NP"} we would want to get 2.
LEN & SUBSTITUTE functions Counting Tricks
See a formula that uses the SUMPRODUCT, LEN and SUBSTITUTE functions.

Got a Question? Ask it Here in the Forum.