Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about how to calculate the weighted mean, or weighted average, a calculation done often in business and accounting. Learn all about the SUMPRODUCT function.
Topics:
1. (00:00) Introduction
2. () Weighted Mean Formula is just a disguised Mean Formula
3. Weighted Mean Helper Column Solution
4. Weighted Mean Single Cell Solution
5. Accounting Weighted Average example to calculate COGS for the Income Statement and Ending Inventory for the Balance Sheet. This formula is used for Inventory Valuation.
6. Weighted Mean short formula with Percent Frequency and X values. This is the second Accounting Example.
7. Summary
8. Conclusion video links