Array formula referencing another workbook

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

Originally Posted by shg

How about =SUMPRODUCT( (Clnt.xls!TFPlanType=11) * (Clnt.xls!TFOwner=0) * Clnt.xls!TFBal) entered normally?

Thank you very much for the help.

That doesn't seem to work either. I'm starting to think it may be a system problem.

I appreciate your time and knowledge!

Kelly

Originally Posted by DonkeyOte

It might help if you outline the specifics behind "doesn't work" - ie wrong result, error value eg #NAME? etc etc...

Without this info. it will be hard for people to help diagnose the problem for you.

When I press CSE the formula doesn't "take" as indicated by {}. It also is returning a zero value when it should be picking up numbers.

Thanks for the help. It was a network problem after all.

Kelly