Quote:
Originally Posted by Spencer101
Hi, try moving the first quote mark to before the < rather than after it.
=averageif(b:b,"<DAL",J:J)
|
Thank you!
Now I realized to get a good weighted average, I need to multiply J:J by its price in H:H, then take the average, but how do I do that?
Column B
Location
CPS
CPS
CPS
DAL
GVT
DAL
MRY
DAL
PHX
Column H
Fuel Purchased
435
783
0
276
0
1792
200
276
300
Column J
Fuel Price
4.21
4.34
6.34
4.24