Forum Discussion

gedijorge's avatar
gedijorge
Copper Contributor
Dec 03, 2022
Solved

SUMIF does not calculate

Hi,

I need your help.

 

Same data, same formula.

Microsoft won't calculate (prints puncture line around the cell), google sheets calculates (right screenshot).

 

Why?

  • gedijorge 

    Do you use a different decimal separator in the "problem" version? Try

     

    =SUMIF(A1:A4;">0")

     

    with ; instead of ,

4 Replies

      • HansVogelaar's avatar
        HansVogelaar
        MVP

        gedijorge 

        Do you use a different decimal separator in the "problem" version? Try

         

        =SUMIF(A1:A4;">0")

         

        with ; instead of ,

Resources