=MIN(IF(

[xander1981]

Hello,

I have a spread sheet detailing my running stats. In the table I list ever race I have entered. In column G there are the distances of each race in miles ie 26.2, 13.1, 10 etc. in Column I there are my finishing times in hh:mm:ss. I need to check each cell in column G against the distance in cell A22 where the MIN will be displayed but I only want the MIN of the races for that specific distaance. I have the following formula but it does not seem to work.

=MIN(IF($G$2:$G$10=A22,$I$2:$I$10))

Any ideas?

[skywriter]

Press control + shift + enter after typing the formula and it should work.

[xander1981]

Sorry Skywriter I should have said I have done that but still not working.

[Rick Rothstein]

Sorry Skywriter I should have said I have done that but still not working.

What exactly to you mean when you say it is "not working"? Your formula, using CTRL+SHIFT+ENTER to commit it, works for me. I will note that the formula outputs a time serial value (that is, a floating point number) which requires the use of Cell Formatting in order to select a proper time display format for the value.

[xander1981]

ScreenCapAJ.jpg Thanks. It should work but returns 00:00:00 as per attached screen cap.