=MAX(INDEX((A1:A7="north")*(B1:B7="high")*C1:C7,0) )


"mwd" wrote:

Hi

I have a spreadsheet that contains text and time information such as below:
a b c
1 north high 5:21
2 south low 6:42
3 north low 7:14
4 north high 3:56
5 east low 2:14
6 north low 2:02
7 north high 2:37
All of the information in the spreadsheet is the result of formulas from
other data (in other sheets).
I need a formula that will provide the maximum time (in Col C) in a row
where (for example) the Col A is "north" and Col B is "high".
Any help would be greatly appreciated.
Thanks.