Cells not summing up correctly
 

: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

Graham


--
Swift
------------------------------------------------------------------------
Swift's Profile: http://www.excelforum.com/member.php...o&userid=35689
View this thread: http://www.excelforum.com/showthread...hreadid=555362

Cells not summing up correctly
 

Please send file. I'm puzzled



--
AP

"Swift" a écrit dans le
message de news: ...

: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

Graham


--
Swift
------------------------------------------------------------------------
Swift's Profile:
http://www.excelforum.com/member.php...o&userid=35689
View this thread: http://www.excelforum.com/showthread...hreadid=555362

Cells not summing up correctly
 

thanks, I have emailed you the file.


--
Swift
------------------------------------------------------------------------
Swift's Profile: http://www.excelforum.com/member.php...o&userid=35689
View this thread: http://www.excelforum.com/showthread...hreadid=555362

Cells not summing up correctly
 

I emailed you my remarks about circular references.

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

Cheers,
--
AP

"Swift" a écrit dans le
message de news: ...

thanks, I have emailed you the file.


--
Swift
------------------------------------------------------------------------
Swift's Profile:
http://www.excelforum.com/member.php...o&userid=35689
View this thread: http://www.excelforum.com/showthread...hreadid=555362

Cells not summing up correctly
 

Ardus Petus wrote:
I emailed you my remarks about circular references.

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

Cheers,
--
AP

"Swift" a écrit dans le
message de news: ...

thanks, I have emailed you the file.


--
Swift


------------------------------------------------------------------------
Swift's Profile:
http://www.excelforum.com/member.php...o&userid=35689
View this thread: http://www.excelforum.com/showthread...hreadid=555362


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

Cells not summing up correctly
 

problem with worksheet: Monthly Data, refer to the year total

Thanks


--
Swift
------------------------------------------------------------------------
Swift's Profile: http://www.excelforum.com/member.php...o&userid=35689
View this thread: http://www.excelforum.com/showthread...hreadid=555362