|  

» Creating a Dynamic Inventory List Based on Daily Sales

Problem:

Columns A & B contain a log of all the sales from a particular day.
Each row consists of the name of an item and the quantity sold.
Columns D & E show the initial inventory for all items.
We want to create formulas in column F that will calculate the current inventory of each item. The formulas should update upon every sale added to the log.

Solution:

Use the SUMIF function in the following formula:
=E2-SUMIF($A:$A,D2,$B:$B)


Rate This Tip
12 34 5
Rating: 2.84     Views: 26720
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments