On Mon, 6 Apr 2009 09:54:05 -0700, Francis
wrote:

Your formula doesn't look right, in your formula,
I don't see the table array or range and the reference to another
is incorrect if you are placing the formula in another sheet.


It is a named range, OBVIOUSLY!

Use your head before you post. Try reading the whole thread even,
before you step in with redundancy or stupidity.