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.