software

I'm also having cicular reference error messages where there are none I.E.
In cell E6 I have this formula and a circular refence error =SUM(F6:G6). In
H157 the formula is =SUM(E157*J157) with an error message.

Marc
Let's start with...
I can't read your 1st question because you put it in the title that scrolls
off the screen. Something about an if statement - quot;I'm desperate I posted
earlier about quot;Ifquot; statements that don't woquot;.
1) Put your questions in the message. The title is used for a BRIEF
descriptor.gt; In cell E6 I have this formula and a circular refence error =SUM(F6:G6).
2) Do you possibly have F6 and/or G6 referencing H6 which looks like it may
have a reference to E6? Have you looked at the Auditing Tool and
'dependents'?gt; In H157 the formula is =SUM(E157*J157) with an error message.
3) What's the error message? If it's a circular error message see answer
(2).gt; In H157 the formula is =SUM(E157*J157) with an error message.
4) Why =SUM(E157*J157) and not simply =E157*J157?Sincerely,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;Marcquot; wrote:

gt; I'm also having cicular reference error messages where there are none I.E.
gt; In cell E6 I have this formula and a circular refence error =SUM(F6:G6). In
gt; H157 the formula is =SUM(E157*J157) with an error message.
gt;
gt; Marc
gt;
gt;
gt;


quot;Gary L Brownquot; gt; wrote in message
...
gt; Let's start with...
gt; I can't read your 1st question because you put it in the title that
scrolls
gt; off the screen. Something about an if statement - quot;I'm desperate I posted
gt; earlier about quot;Ifquot; statements that don't woquot;.
gt; 1) Put your questions in the message. The title is used for a BRIEF
gt; descriptor.
gt;
gt;
gt; gt; In cell E6 I have this formula and a circular refence error =SUM(F6:G6).
gt; 2) Do you possibly have F6 and/or G6 referencing H6 which looks like it
may
gt; have a reference to E6? Have you looked at the Auditing Tool and
gt; 'dependents'?

Yes, Yes

gt;
gt;
gt; gt; In H157 the formula is =SUM(E157*J157) with an error message.
gt; 3) What's the error message? If it's a circular error message see answer
gt; (2).

Yes

gt;
gt;
gt; gt; In H157 the formula is =SUM(E157*J157) with an error message.
gt; 4) Why =SUM(E157*J157) and not simply =E157*J157?
gt;

I don't remember and probably have no good reason but it shouldn't make a
difference.Marc

gt;
gt; Sincerely,
gt; --
gt; Gary Brown
gt;
gt; If this post was helpful, please click the ''Yes'' button next to ''Was
this
gt; Post Helpfull to you?''.
gt;
gt;
gt; quot;Marcquot; wrote:
gt;
gt; gt; I'm also having cicular reference error messages where there are none
I.E.
gt; gt; In cell E6 I have this formula and a circular refence error =SUM(F6:G6).
In
gt; gt; H157 the formula is =SUM(E157*J157) with an error message.
gt; gt;
gt; gt; Marc
gt; gt;
gt; gt;
gt; gt;