Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find components of an Average Result | Excel Worksheet Functions | |||
=AVERAGE returning a #DIV/0! result | Excel Worksheet Functions | |||
Average function not returning expected result | Excel Discussion (Misc queries) | |||
Getting #NUM! result for SumProduct | Excel Worksheet Functions | |||
formula result #value! needs to equal zero for average calculation | Excel Worksheet Functions |