E
EricB
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
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