If you'd like, you can send me your file and I'll look at it right away
to see if I can pinpoint problem. If you're interested, you can email
me at (remove any personal/confidential
information). Otherwise, I'll give it more thought and get back to you
if and when I have any other suggestions.

In article ,
"Coal Miner" wrote:

Domenic,

Welllll, the formulae I have had in my workbook are correct. There must be
a setting or something on the specific worksheet that I am working in for
this not to be working.

Just to check that I had my formula correct, I input the exact scenario I
gave you into a new worksheet in my workbook and as expected it worked fine.

Then, I put the exact information on the worksheet I am needing the formulae
on and it shot craps again. All is working excpet it is not excluding the
cells we are indicating (i.e. f4). Don't have a clue as to why it is
occurring on this particular worksheet?!?!?