Hi,
I think the problem is that L9 is empty or 0 try

=if(or(L9="",L9=),0,INDIRECT($A5&"!"&B$4))

"BNT1 via OfficeKB.com" wrote:

Hi

Currently using this formula in cell =INDIRECT($A5&"!"&B$4) A5 contains
the sheet number, and B4 contains a value. All works well

What I want to do now is amend to show the value in L9, instead of B4, but
keep getting REF# error. Incidentally, L9 does contain a sum formula

All help appricaiated

regards

--
Message posted via http://www.officekb.com