» Creating a Dynamic Inventory List Based on Daily Sales
CATEGORY - Excel Financial Formulas
VERSION - All Microsoft Excel Versions
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)
Book Store:
Recommended Books:
- Accounting the Easy Way
- Financial Modeling - 2nd Edition
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
No comments have been submitted.
