PDA

View Full Version : Solved: Subtracting Totals



Holland
11-11-2010, 03:43 PM
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

Bob Phillips
11-11-2010, 04:01 PM
Try

=$C2-SUMIF($B$9:$B$17,$B2,$C$9:$C$17)

Holland
11-11-2010, 08:56 PM
XLD, THANK YOU very much, works great!

Holland