Why would you use SUM to "subtract one cell from another" ?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"bmoag" wrote in message
...
Using the sum function in a blank cell to subtract one cell from another
in a row Excel keeps telling me I am using a circular reference and will
not perform the calculation.
If I move over one cell and enter the same formula all works as it should.
Unbelievable: I think Excel is probably the cause of the stock market
meltdown because this dog can't hunt.