Dueling Excel 101


Sum Numbers from Cells That Contain Both Text & Numbers

DESCRIPTION

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

WORKBOOKS




Be the first to comment

Leave a Reply