Forum Discussion
Excel - Newbie - "If" Help
I have been requested to create an inventory Excel Sheet. I need to track Monitors, Mouse, Keyboard, Cable. Each will begin with a fix number (example 10, 20, 35, 15). I created a pulldown for each ...
In F3:
=F2-SUMIFS($E$6:$E$10000, $C$6:$C$10000, F1, $D$6:$D$10000, "BORROW")+SUMIFS($E$6:$E$10000, $C$6:$C$10000, F1, $D$6:$D$10000, "ADD")+SUMIFS($E$6:$E$10000, $C$6:$C$10000, F1, $D$6:$D$10000, "RETURNED")
Fill to the right to I3.
HansVogelaar
I just saw your reply. I will give it a try. Thanks for responding!