First of all you don't need the SUM part since you are summing nothing, only
referring to one cell.

Did you mean ='Daily Sworn Status'!M8

But the REF error must come because you don't have a sheet named

Daily Sworn Status


Gord Dibben MS Excel MVP

On Wed, 12 May 2010 15:51:01 -0700, da wrote:

Hi
When I use the following formula, I get #REF error.
How can I fix it?
Thank you

=SUM('Daily Sworn Status'!M8)