I've tried both suggestions posted, however neither is working. After
trying the suggestions, I checked the formatting for the cells in
question, and they show to be number formatted, however I still get 0
when I sum them.


--
telewats
------------------------------------------------------------------------
telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=500378