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

## Leave a Reply

You must be logged in to post a comment.