Yes, it can. No, that is not correct. What formula can't you get to work?
--
David Biddulph

"Ken G." wrote in message
...
If in "Sheet A" I have a formula =sum('Sheet B'!C1:C10) can the indirect
function be used on one of the arguments in the sum equation? I can't get
it
to work so I'm thinking it can't be used to reference another sheet. Is
that
correct?