B
BobT
Thanks to Biff for the last response.
One more for the group: Can I reference the "=", "<",
or ">" etc sign in a SUMPRODUCT function of the following
form:
"=SUMPRODUCT((Range1=Criteria1)*(Range2>Criteria2)*
(Range3<Criteria3)"
I can use an indirect to reference the range, and direct
references to the criteria. In countif and sumif functions
I can direct reference "=", "<", or ">" etc signs but
can't seem to get it right for this sumproduct function.
If you have a way, please check out the min, max and mode
formulae below for the same question.
Thanks
BobT
Hi!
All are array formulas, enter with the key combo of
CTRL,SHIFT,ENTER:
=MODE(IF(A1:A10="x",IF(B1:B10="y",IF(C1:C10="z",D110))))
=MIN(IF(A1:A10="x",IF(B1:B10="y",IF(C1:C10="z",D110))))
=MAX(IF(A1:A10="x",IF(B1:B10="y",IF(C1:C10="z",D110))))
Biff
One more for the group: Can I reference the "=", "<",
or ">" etc sign in a SUMPRODUCT function of the following
form:
"=SUMPRODUCT((Range1=Criteria1)*(Range2>Criteria2)*
(Range3<Criteria3)"
I can use an indirect to reference the range, and direct
references to the criteria. In countif and sumif functions
I can direct reference "=", "<", or ">" etc signs but
can't seem to get it right for this sumproduct function.
If you have a way, please check out the min, max and mode
formulae below for the same question.
Thanks
BobT
Hi!
All are array formulas, enter with the key combo of
CTRL,SHIFT,ENTER:
=MODE(IF(A1:A10="x",IF(B1:B10="y",IF(C1:C10="z",D110))))
=MIN(IF(A1:A10="x",IF(B1:B10="y",IF(C1:C10="z",D110))))
=MAX(IF(A1:A10="x",IF(B1:B10="y",IF(C1:C10="z",D110))))
Biff