With INDIRECT, the cells must then be in quotes, like

=SUM(A1&"!C1:C10")



--
__________________________________
HTH

Bob

"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?