Excel Forum
Similar Content
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...
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 Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
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 416: Add Invoices w Same Prefix (Number v Text problem examined)


See how to look through a list of Invoice numbers and add only the ones that have a Prefix of 55 or 58 or 7E.

Learn about how Excel treats numbers and text differently. For example "55" does not equal 55. This matters for TRUE FALSE formulas.

See why SUMIF function will not work, but SUMPRODUCT and LEFT functions will work. This is from a post at the Mr Excel Message Board.





Got a Question? Ask it Here in the Forum.