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 cell in column C contains "laptop charger" then take value in column D from cell I5 (this is the total no. of item in stock), but it doesn't recognise anything I write as an actual formula.
I can make it work if I only choose one cell to look at, at a time but not when i try and look through the whole column of values.
Hopefully this makes sense.
Thank you,
Sophie
2 Replies
=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.
