Exel summing problem

I have recently been experiencing an intermittent problem with summing using auto sum and with the basic sum+ then +what ever cells I want to sum Answer I get is 0.00 I have tried reformating, forc...