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?
excel
  • HansVogelaar's avatar
    HansVogelaar
    Dec 03, 2022

    gedijorge 

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

     

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

     

    with ; instead of ,

gedijorge's avatar
gedijorge
Copper Contributor
Dec 03, 2022

NikolinoDE 

 

Tried it before.

Tried it again now.

 

Result stays the same.

 

 

 

HansVogelaar's avatar
HansVogelaar
MVP
Dec 03, 2022

gedijorge 

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

 

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

 

with ; instead of ,

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

    HansVogelaar 

     

    It worked!

     

    Thank you. 

Resources