Excel the sum of my cells is 0

MegumiTo -  
 BONKOJean -
Hello,

I am encountering a problem that I can't resolve. I went to format, I set it to number format, but my total still displays as 0.
What I don’t understand is that the adjacent line works correctly...
Thank you for your help

Configuration: Macintosh / Chrome 56.0.2924.87

4 answers

  1. ccm81 Posted messages 11033 Status Member 2 434
     
    Hello to both of you

    Your "population" data in column B is in text format.
    To transform it into numbers
    - put 1 in a cell, for example in E14
    - select that cell
    - Edit Copy
    - Select the range B2:B47
    - Edit/Special Paste/Multiply

    Everything should work out fine
    http://www.cjoint.com/c/GDnuR5tX4Bs

    Best regards
    2