Numbers that are stored as text can cause unexpected results, especially when you use these cells in Excel functions such as SUM and AVERAGE because these functions ignore cells that have text ...

To fix this issue, remove the text and add the cost price. If you are using the Sum function, it will ignore the text and add the numbers of the two items in the spreadsheet.

You can sum a series of numbers in Microsoft Excel manually by typing in a simple formula, or automatically with a tool.

Sometimes the current Microsoft Excel data structure doesn’t match requirements of other users and software. Learn how to combine columnar values into a single cell using Microsoft Excel’s ...