Hi!

Is this because it's reading blank cells as zero's?

Yes

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=MIN(IF(D8:D73="H",IF(ISNUMBER(F8:F73),F8:F73)))

Biff

wrote in message
oups.com...
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