Hi Eric

Try this, in one formula line (has not been tested):

=SUMPRODUCT(--(crq!$C$2:$C$65536="Debit
Order"),--(crq!$D$2:$D$65536="FNB"),--(crq!$H$2:$H$65536="APP"),--(crq!$Z$2:$Z$65536=550),--(crq!$Z$2:$Z$65536<=650),crq!$J$2:$J$65536)/SUMPRODUCT(--(crq!$C$2:$C$65536="Debit
Order"),--(crq!$D$2:$D$65536="FNB"),--(crq!$H$2:$H$65536="APP"),--(crq!$Z$2:$Z$65536=550),--(crq!$Z$2:$Z$65536<=650)

Hopes this helps.

---
Per


"EricB" skrev i meddelelsen
...
SUMPRODUCT with AVERAGE result

Formula refers:
=SUMPRODUCT(--(crq!$C$2:$C$65536="Debit
Order"),--(crq!$D$2:$D$65536="FNB"),--(crq!$H$2:$H$65536="APP"),--(crq!$Z$2:$Z$65536=550<=650),crq!$J$2:$J$65536)

1) What criteria do I use to pickup records being equal to and greater
than
550 but not exceeding 650?
2) I need to get the AVERAGE of the result in Column J, what do I do to
get
an AVERAGE?

At present my result is 0

Regards

EricB