Forum Discussion
SUMIF in stock tracking
Hi all, Sorry if a question like this has been asked before but I'm trying to write a SUMIF formula to live track when stock is taken from a base amount. I'm essentially trying to write SUMIF a ...
=SUMIF($C$1:$C$23,H5,$D$1:$D$23)You can try this formula. It dynamically updates the quantity of items.
Thanks for this. I was trying to also subtract the total value from a current stock value but i think I'll have to create some hidden helper columns.