MIN IF and STDEV IF while ignoring blank cells

Hi all,

I'm trying to summarize data with AVG, MIN, MAX, AND STDEV, all ignoring null entries in the data.

I have managed to do this easily with the AVERAGEIF and MAX(IF(...)) functions but am having difficulty getting the MIN and STDEV functions to ignore the null cells. (Note: My version of Excel does not have MINIFS function or MIN/MAX/STDEV function equivalent to AVERAGEIF.)

The AVERAGEIF and MAX functions I am trying to replicate:

Formula:

=AVERAGEIF($A$2:$A$1000,$A2,$F$2:$F$1000)

Formula:

{=MAX(IF($A$2:$A$1000=$A2,$F$2:$F$1000))}

Thanks in advance!