Prev: CAN I PERMANENTLY CHANGE COLORS IN THE 2003 EXCEL PALETTE
Next: Inserting automatic page breaks
From: da on 12 May 2010 18:51
Hi
When I use the following formula, I get #REF error.
How can I fix it?
Thank you

=SUM('Daily Sworn Status'!M8)
From: p45cal on 12 May 2010 19:08

probably a misspelling of the sheet name



d
a
;
7
2
2
6
8
6

W
r
o
t
e
:


>
Hi
> When I use the following formula, I get #REF error.
> How can I fix it?
> Thank you
>
> =SUM('Daily Sworn Status'!M8)


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=202394

http://www.thecodecage.com/forumz

From: Gord Dibben on 12 May 2010 19:13
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 <da(a)discussions.microsoft.com> wrote:

>Hi
>When I use the following formula, I get #REF error.
>How can I fix it?
>Thank you
>
>=SUM('Daily Sworn Status'!M8)

From: Dave Peterson on 12 May 2010 19:19
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
From: da on 13 May 2010 11:19
Thank you to all who responded.
Yes, I do have a worksheet that is named "Daily Sworn Status', which is in
the same file.
I also tried to change the formula by taking out Sum, and still I get the
same error#ref. And I also checked the spelling and it is correct (I copied
the name of the worksheet to avoid spelling mistake.)

It is a mystery which took all my yesterday.


"p45cal" wrote:

>
> probably a misspelling of the sheet name
>
>
>
da;722686 Wrote:
> >
> Hi
> > When I use the following formula, I get #REF error.
> > How can I fix it?
> > Thank you
> >
> > =SUM('Daily Sworn Status'!M8)
>
>
> --
> p45cal
>
> *p45cal*
> ------------------------------------------------------------------------
> p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
> View this thread: http://www.thecodecage.com/forumz/showthread.php?t=202394
>
> http://www.thecodecage.com/forumz
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: CAN I PERMANENTLY CHANGE COLORS IN THE 2003 EXCEL PALETTE
Next: Inserting automatic page breaks