averageif cell doesn't contain "text"

[dkte737]

Hello, I have some data below I want to average but only if Column
does not have "DAL". I had =averageif(b:b,<>"DAL",J:J) but it doesn'
like it. Any help?

Column B
CPS
CPS
CPS
DAL
GVT
DAL
MRY
DAL



Column J
435
783
0
276
0
1792
200
27

 

[Claus Busch]

Hi,

Am Wed, 18 Jul 2012 04:57:03 +0000 schrieb dkte737:

Hello, I have some data below I want to average but only if Column B
does not have "DAL". I had =averageif(b:b,<>"DAL",J:J) but it doesn't
like it. Any help?

try:
=AVERAGEIF(B:B,"<>DAL",J:J)


Regards
Claus Busch

 

[dkte737]

Hi, try moving the first quote mark to before the <> rather than afte
it.

=averageif(b:b,"<>DAL",J:J)

Thank you!

Now I realized to get a good weighted average, I need to multiply J:J b
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.2