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 ToolTips on Mouse Hover for Buttons and Shapes
Tutorial: Excel trick to add ToolTips to any of your shapes when a user hovers over them in a works...
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...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.