Cells not summing up correctly

S

Swift

:mad: 'SUM' Results are showing as '0.00' in cells.

3.00 + 0.00 + 0.00 = 0.00 (cell should be 3.00)

I could send the file if anyone wants to check it out.

Thanks

Graha
 
A

Ardus Petus

I emailed you my remarks about circular references.

BTW: where was the faulty formula (SUM).
The are so many worksheets!

Cheers,
 
E

ed

Ardus said:
I emailed you my remarks about circular references.

BTW: where was the faulty formula (SUM).
The are so many worksheets!

Cheers,
--
AP

Swift said:
thanks, I have emailed you the file.
Click to expand...
Click to expand...

You don't have an = sign in front of the formula. If that doesn't
work, got to your Tools menu / Options / Calculation. Make sure you
mark Automatic under Celculations and mark Iterations, at least 100.
Hope that helps.

ed
 
Top