Excel automatically capitalizes formulas which are not entered as
capitalized. That wouldn't explain the issue.
--
Brevity is the soul of wit.


"Dana DeLouis" wrote:

For debugging, I notice that "sum" is not Capitalized.
"=sum(A1+B1)"

A proper working formula would most likely be in all Capitals:
=SUM(A1,B1)

(note that A1+B1 "is" the sum)

Also, try the "Evaluate Formula" toolbar button located on the Formula
Auditing toolbar.
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"Steven Sinclair" wrote in
message ...
No warnings...no errors.

Just Excel's apparent inability to do basic math.

I can open up a fresh worksheet and put one figure in A1, another in B1,
add
them together in C1, and the total is always 672 more than it should be.

Thanx.

"Harald Staff" wrote:

Or worse, you may have circular references in your workbook. Any warnings
when you open it ? Better read it if so, this is a very dangerous error.

HTH. Best wishes Harald

"Marcelo" skrev i melding
...
hi,

your calculation should set as manual, to calculate press F9,

go to Tolls | Options and set calc as automatic

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Steven Sinclair" escreveu:

Here's the deal...

Open Excel
New worksheet
Enter data
Sum data

No matter whether I add numbers from column to column or row to row,
my
totals are always off by exactly 672. What the heck is that?!

Example...

A B C
140785 276714 418171

Formula in C is "=sum(A1+B1)

How much simpler can it get?

Any ideas?