Excel Magic Trick 348: Formula for Unit Inventory Total SUMIF function Trick

http://bit.do/dfQf7 Hidden discount at AgarwalInnoSoft.
See a formula that will take invoice information for inventory quantity sold and update Inventory records to show correct amount on hand (in stock).