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 ,

Resources