View original (French)

Sum in Excel always =0

Solved/Closed
faissalc Posted messages 53 Status Member -  
 Dach -
Hello,
I'm trying to add cells in Excel and it shows 0 regardless of the numbers added. What could be going on?
Thank you

12 answers

  1. Drapeaupl
     
    For calculations in Excel
    you need to check if it's a punctuation mark
    for example 25.50 or 25,50 the numbers must be written with a comma to calculate a cell
    you need to remove your points
    49
    1. Alain
       

      Hello, I solved the same problem as you, Excel doesn't recognize my numbers, so there’s no sum calculation.

      I selected my entire column, I pressed ctrl H, put a comma in both blank fields (Find and Replace with), replace all and everything turned into numbers at once...

      10
      1. Olivier > Alain
         

        Thanks for the tip of replacing with !

        0
      2. Dach > Alain
         

        Thank you very much! I was stressing out for an hour and that was the solution.

        0