Main Profile

At A Glance

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.
Length: 06:55

Contact

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

Want more info about Excel Magic Trick 291: Add Nums Associated w Codes From String? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question