MAX/MIN with SUMPRODUCT

[neil40]

Hi folks

I am using the following:
=IF($F$8="",0,SUMPRODUCT(MAX(($D$8:$D$73="H")*($F$8:$F$73))))
to show the highest attendance in a seasons fixture list.
Thus this changes as each game is completed and I fill the attendance.
The IF part is just to put in a 0 if the season hasn't started.
However, if I use that same formula with MIN,
=IF($F$8="",0,SUMPRODUCT(MIN(($D$8:$D$73="H")*($F$8:$F$73))))
I just get a 0
Is this because it's reading blank cells as zero's?
If so, how do i overcome this to just find the lowest value among
values entered (ignore blank cells)

Many thanks
Neil

 

[Jerry W. Lewis]

=IF($F$8="",0,SUMPRODUCT(MIN(($D$8:$D$73="H")*ISNUMBER($F$8:$F$73)*($F$8:$F$73))))

Jerry