janema
Board Regular
- Joined
- Nov 28, 2022
- Messages
- 155
- Office Version
- 365
- 2021
- 2019
- 2011
- 2010
- Platform
- Windows
- Mobile
Hi, I am confused at how I need to write a weighted average formula. I need the weighted average of Column F (Average Gap) shown in the image, but am not sure if I need to reference another column as many excel sites are instructing. That part doesn't make sense to me. 
The formulas to calculate the average gap in column F is =(C2-D2)/B2
However, I am not understanding what it is weight again in the weight average excel formulas. Clearly the first formula I tried is wrong, because it came out to a weighted average of $9.30
1st attempt: =SUMPRODUCT(B2:B15,F2:F15)/SUM(F2:F15)

The formulas to calculate the average gap in column F is =(C2-D2)/B2
However, I am not understanding what it is weight again in the weight average excel formulas. Clearly the first formula I tried is wrong, because it came out to a weighted average of $9.30
1st attempt: =SUMPRODUCT(B2:B15,F2:F15)/SUM(F2:F15)