Many thanks for quick reply, i am so sorry if i wasn't clear earlier. I will try to explain again this time with example.

A B C D E
code total sold remaining
1 cush01 10 5 5
2 hamm01 10 4 6
3 2ss01 10 1 9

Formula that runs under D1 is =countif(110:I1000,"cush01")
Formula that runs under D2 is =countif(110:I1000,"hamm01")
Formula that runs under D3 is =countif(110:I1000,"s2201")

this is how i do entries:
Jo Smith 0777177777 Jo.S@gmail.com <Address> cush01 12.00 GBP

this way, the sale is reflected in cell D1 and E1 calculates remaining stock by subtracting C1-D1

But I am having to create separate entry if customer buys more than 1 product, like this one, where Jo Smith also bought Hammock
Jo Smith 0777177777 Jo.S@gmail.com <Address> hamm01 99.00 GBP

What I want is a formula that calculates and reflects the sale in D1, D2, D3 just by entering multiple codes in single cell

May be something like this (note both codes appear in single cell)
Jo Smith 0777177777 Jo.S@gmail.com <Address> cush01, hamm01 111.00 GBP

Can you please advice what formula should go in cell D1, D2 and D3 so that it looks for their respective code and show sale against it

Sorry to be a pin, but is this possible?