To sum values in a column up to a point where a specific condition is met (e.g., encountering a blank cell or specific text), you can combine the SUM function with the INDEX and MATCH functions.

This was how to sum cells with text and numbers in Excel. To wrap it up, adding numbers in Excel that are mixed with words is easy once you know how. With simple tricks like LEFT, FIND, or SUBSTITUTE, ...

4. Remove text formatting from cells. The Excel SUM function will not add up any values that are in cells with text formatting, which display text numbers on the left of the cell instead of the right ...