How to format spreadsheet to accommodate 1 item with multiple buyers

[petartist1]

Hello and Thank-you all for looking at my question.

I’m not sure how to word my question to get a proper answer.

I want to do some inventory “control”

I have a spreadsheet made out and have a formula that deducts everytime an item is sold.
My problem is, how do I deduct with multiple buyers for 1 product.
Apple buyer bought 10 apples out of 100…. Formula deducts 10 with a balance of 90.
Triangle buyer bought 5 apples, restaurant bought 22 etc.
How do I format my spread sheet to accommodate one item with multiple buyers that will deduct everytime the item is sold?

 

[Dendro]

create a table with buyers in the rows in the first column.The columns of the table would hold the amount of each product bought. At the bottom set a formula to sum the amounts of each product, and use this to deduct from your stock.
f.i.:

Buyers	Apples	Tomatoes	Pineapple
Apple buyer	10
Triangle buyer	5		10
Restaurant buyer	22	30	4
SUM:	65	30	14

<tbody>
</tbody>

Stock of fruit	initial stock	sold	New stock
Apples	100	65	=[@initial stock]-[@sold]
Tomatoes	100	30	=[@initial stock]-[@sold]
Pineapple	100	14	=[@initial stock]-[@sold]

<tbody>
</tbody>