SUMIF does not calculate

[gedijorge]

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?

[#2]

@gedijorge 

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

It should work like this :)

[#3]

@NikolinoDE 

Tried it before.

Tried it again now.

Result stays the same.

[#4 · Accepted solution]

@gedijorge 

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

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

with ; instead of ,

[#5]

@Hans Vogelaar 

It worked!

Thank you.