View original (French)

Sum in Excel always =0

Solved/Closed
faissalc Posted messages 53 Status Membre -  
 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 réponses

Réponse 1 / 12
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
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
Olivier > Alain
 

Thanks for the tip of replacing with !

0
Dach > Alain
 

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

0