Folks

I'm trying to enter an array formula that works great within one workbook. However, when I enter the same formula with the formula referencing columns in a separate workbook, I do not get the {} brackets that indicates an array.

Both workbooks are open when I try to enter the formula.

This is the formula

=SUM((Clnt.xls!TFPlanType=11)*(Clnt.xls!TFOwner=0)*Clnt.xls!TFBal)

As you can see the formula is using range names.

My hope is that I can get this to work with the Clnt.xls book closed and just the book containing the array formula open.

Any suggestions??

Thank you!

Kelly