I need to subtract Ordered Qty from Inventory Qty and have the running total in Column D under Remaining Qty for each item. Any help would be greatly appreciated.
Feel really, really silly for asking for help on this one, I tried If Statements, SumIF, IF with Vlookup. Just can't get it right.
Thank you in advance,
Holland McAdam
Try
=$C2-SUMIF($B$9:$B$17,$B2,$C$9:$C$17)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
XLD, THANK YOU very much, works great!
Holland
Posting Permissions
Reply With Quote
