Struggling using countif

Hi,
we sell many products online and in an effort to reduce cost, i have created excel sheet with various formula's for inventory
This is how excel looks like
a1: Cushions (code i use is "Cush01")
a2: Hammock (code i use is "Hamm01")
a3: 2 seat sofa (code i use is "2ss01")

I use =CountIF(A10:A1000,"Cush01") and straight away we know how many cushions we have sold at a given time and whats the remaining stock of cushions.
But 1 customer can buy multiple items, like cushions, hammock, 2 seat sofa etc. At the moment, for every item we have to create 3 entries in excel.

Question: Can I use CountIf or any other formula to look for multiple codes in a cell that I have crated and reduce stock against the item purchased?

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?

CountIF.jpg

kindly find attached screen shot