Adding multiple numbers in one cell to give a total in another

[Lunezilla]

Hi all,

I've had a bit of experience with excel doing costing databases etc, but i'm drawing a bit of a blank with what i want to achieve with a new spreadsheet. Basically it's a stock sheet for different components, their batch numbers and quantity per batch. To make it easier on the eye and to see what current levels are like i have stacked multiple batch numbers per item in one cell, as i have with the quantity. What i want to do is be able to add the quantity values from the cell together and output the total into another cell to give an overview of total stock. I have attached (I hope) a section of the list to make it easier to understand my intentions. If anyone has any useful input I would be most grateful.

Lune


Stock list.jpg

[martindwilson]

To make it easier on the eye ? well now you found that easy on the eye is not so good for calculations! you can achieve the same efect by hiding grid lines and setting cell borders and still have data in separate cells