Doesn't B4 need to contain a cell reference, whereas a sum formula returns a
number?

--
__________________________________
HTH

Bob

"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:9a1768a3caeab@uwe...
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