Stock Control help

[Neates - ExcelForums.com]

I am doing some AS ICT Coursework. Can anybody tell me the formulae
you have to use to update the stock level once you enter the product
code and quantity of incoming stock? :?

 

[Tom Ogilvy]

Assuming you have a database of transactions including the initial stockage
level, you can do a sum

=sumif(Data!A:A,C9,Data!B:B)+C10

where C9 holds the product code.
and C10 holds the incoming stock.

On the sheet data, the database of productcodes in column A and
quantity/transaction amount in column B.