Re: MAX/MIN with SUMPRODUCT

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"Biff" wrote:
....
> =MIN(IF(D8:D73="H",IF(ISNUMBER(F8:F73),F8:F73)))

To align with what the OP posted, suggest just a slight tweak to the above
array formula <g>:

=IF($F$8="",0,MIN(IF($D$8:$D$73="H",IF(ISNUMBER($F$8:$F$73),$F$8:$F$73))))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----


.

Relevant Pages