View original (French)

Google Sheets sum displays incorrect result

NewSheet -  
DjiDji59430 Posted messages 4277 Registration date   Status Membre Last intervention   -
Hello,
I don't understand why when I use the formula sum(a1:a5) the displayed result is not the same as if I do a1+a2+a3+a4+a5.

Do you have any idea what is happening? Thank you.

Configuration: iPhone / Safari 12.1

1 réponse

Réponse 1 / 1
DjiDji59430 Posted messages 4277 Registration date   Status Membre Last intervention   716
 
Hello everyone,

Make sure that all your cells contain a number and not text, like 221space or something else.

Best regards
0
NewSheet
 
Actually, I think it's because there was a filter and the hidden rows were also included in the calculation. I don't know how to disable that, so I copied and pasted it onto another sheet. Thank you very much for your help!
0
DjiDji59430 Posted messages 4277 Registration date   Status Membre Last intervention   716 > NewSheet
 
So, you had to use =SUBTOTAL(9;range)

Best regards
0