View original (French)

Google Sheets sum displays incorrect result

NewSheet -  
DjiDji59430 Posted messages 4278 Registration date   Status Member 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 answer

  1.
    DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717
     
    Hello everyone,

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

    Best regards
    0
    1. 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
      1. DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717 > NewSheet
         
        So, you had to use =SUBTOTAL(9;range)

        Best regards
        0