Quote:
Originally Posted by 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?
Column B
CPS
CPS
CPS
DAL
GVT
DAL
MRY
DAL
Column J
435
783
0
276
0
1792
200
276
|
Hi, try moving the first quote mark to before the < rather than after it.
=averageif(b:b,
"<DAL",J:J)