Very simple stock take...

Hdavis98

Good morning! I have a simple stock take i'm trying to sort out for daily use, ideally i'd like to input a value into the IN column and this would automatically add it to the value already in-stock and again for the OUT column id like it to subtract from the value in stock. Is there a way to do this?

Many thanks.

Paul Newcome

You would have to have somewhere to store the initial count if you are not starting from zero. This can be hard coded into a formula or set up in a reference table.

The formula though would be adding the In column and Subtracting the Out column.

=SUMIFS(In:In, Chemical:Chemical, @cell = Chemical@row) - SUMIFS(Out:Out, Chemical:Chemical, @cell = Chemical@row)