Excel Forum
Similar Content
Excel Formatting for Zip Codes and Phone Numbers
Tutorial: Display numbers in Excel as zip/postal codes and phone numbers in order to make them easi...
Excel VBA MsgBox - Message Box Macro
Tutorial: Create a pop-up message box in Excel using VBA Macros. This allows you to show a message t...
Extract the First Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Macro: This free Excel UDF (user defined function) returns the first word from a cell in Exce...



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.