Dueling Excel 101

Sum Numbers from Cells That Contain Both Text & Numbers


See Mr Excel and excelisfun use two methods to add the numbers from cells that have both numbers and text. See these tricks:
1. LEFT and IF Functions to extract numbers and then add
2. Left function and then the plus symbol to add numbers that are text (because SUM Function ignores text, but plus symbol does not
3. Single cell array formula that uses IF LEFT and SUM
4. Text To Columns and Custom Number Formatting
5. Apply General Number Format with: Ctrl + Shift + Enter


Be the first to comment

Leave a Reply