View original (French)

Excel, Formula =SUM not working

Solved
Damien -  
speug Posted messages 67 Status Member -
Hello,

I just summed several cells as usual, but I notice that the formula is giving me a result that is incorrect...

http://cjoint.com/?3CvlmprQIMv

See the attached file.
How can I resolve this issue?
Thank you in advance
Configuration: Windows XP / Internet Explorer 7.0

4 answers

  1.
    chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   1 313
     
    Hello,

    the problem comes from numbers stored in text format. Where do your data come from?

    To avoid this problem, convert all your cells to 'Number' format.

    Best regards.
    --
    This guy wasn't very bright, as he was naïve.
    6
    1. Damien
       
      Hello, chossette9
      That's what I've done and it still doesn't work
      Right click/cell format/Number
      I'm using Excel 97
      3