Hi ... first time here !!

Probably a simple problem. I've got a range of cells let's say F39:M39.
I want to select the lowest value 0. What I'd call a MINIF. No mention
in Excel. Some scouting around on the Web refers to CSE formulas. But I
can't seem to get it to work.

I'm trying .... =min(if(F39:M390) and the Control / Shift / Enter ??

Do I have to activate CSE in Excel first or am I just doing it wrong ?

Thanks

JH


--
JohnHill
------------------------------------------------------------------------
JohnHill's Profile: http://www.excelforum.com/member.php...o&userid=25171
View this thread: http://www.excelforum.com/showthread...hreadid=386666