View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EricB EricB is offline
external usenet poster
 
Posts: 42
Default SUMPRODUCT with AVERAGE result

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