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:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

Thanks in advance!

Hi and welcome
Have a look at the AGGREGATE function http://www.exceluser.com/excel_help/...-aggregate.htm