I am fairly new to Excel and only using it for a hobby, however I have noticed that when I attempt to add an entire column of values together, there is one value that is not included in the addition. It is also the only 'non-defined' value of the column (i.e. it is calculated using a formula rather than being inputted directly). When I go to edit the formula I see that the value in question (in the below screenshot 24.99), it seems to be a string given the speech marks either side of it, hence why it isn't in the addition.

[![row of values in the column](https://i.stack.imgur.com/CDs7a.png)](https://i.stack.imgur.com/CDs7a.png)
[![list of relevant values](https://i.stack.imgur.com/hjkoO.png)](https://i.stack.imgur.com/hjkoO.png)

I am confused as when I reference only that value in a sum, the value is included in the sum, as seen below:

[![number used as value](https://i.stack.imgur.com/VeNCy.png)](https://i.stack.imgur.com/VeNCy.png)

Before it is suggested, I have experimented with using different data types for the value in the cell, including 'Currency', which is what the rest of the cells in the column are, as well as 'Number', 'Accounting', and 'General'. One thing that is strange is that the £ symbol never appears at the front of the number, no matter what data type it's casted as.

For those that are curious, the formula that is used to get the number in the cell B9 is below, where H13 is a number in the form 'Currency', and J13 is a number in the form 'General'.

`=IMPRODUCT(H13,J13)`