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. (00:40) Weighted Mean Formula is just a disguised Mean Formula
3. (01:55) Weighted Mean Helper Column Solution
4. (03:44) Weighted Mean Single Cell Solution
5. (04:51) 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. (08:26) Weighted Mean short formula with Percent Frequency and X values. This is the second Accounting Example.
7. (10:43) Summary
8. (11:12) Conclusion video links