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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2