Here is a solution for anyone that could use it.

from a gentleman at another board:

=SUMPRODUCT(--(C7:C1000="Europe"),--(D7:D1000="Equity"),--(E7:E1000="Urgent"),--(F7:F1000="Inactive"),--(W7:W1000<"ERROR"),J7:J1000) / SUMPRODUCT(--(C7:C1000="Europe"),--(D7:D1000="Equity"),--(E7:E1000="Urgent"),--(F7:F1000="Inactive"),--(W7:W1000<"ERROR"))

Or if you use Excel 2007 or newer:

=AVERAGEIFS(J:J,C:C,"Europe",D:D,"Equity",E:E,"Urg ent",F:F,"Inactive",W:W,"ERROR")