Biff:
Using H:H and G:G produced #num!
Editing to H3:H50 and G3:G50 produced $7,500.00 << Correct Amt
Both entered as CSE.
Are complete column references not usable for some reason?
TIA,
Jim

"Biff" wrote in message
...
Hi!

If I'm not clear enough

Well, I'll take a guess anyhow!

Entered with the key combo of CTRL,SHIFT,ENTER:

=MIN(IF(H:H<"X",G:G))

Biff

"One-Leg" wrote in message
...
I'll try to explain my situation...

I have a budget in Excel that goes until the end of 2006.

In one colum ("G"), I have the remaining balance of my bank account. In
the
next colum ("H"), I put an X in the cells where the dates have allready
passed.

I would like to have, in cell "F2", the lowest amount of money I have
left
until the end of my budget.

If I'm not clear enough, please send my a private message and I'll send
you
an example of what I'm looking for...

Thanks!!!