Reference cell error
 

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

=SUM('Daily Sworn Status'!M8)

Reference cell error
 

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)

Reference cell error
 

And if it's not a typo in the sheet name...

Any chance that you have a #Ref! in M8 of that sheet?

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)

--

Dave Peterson