SOLVED

SUMIF does not calculate

New Contributor

Hi,

I need your help.

 

Same data, same formula.

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

 

exc2.jpg

Why?

4 Replies

@gedijorge 

 

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

 

It should work like this

 

 

@NikolinoDE 

 

Tried it before.

Tried it again now.

 

Result stays the same.

 

gedijorge_0-1670070106592.png

 

 

best response confirmed by Sergei Baklan (MVP)
Solution

@gedijorge 

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

 

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

 

with ; instead of ,

@Hans Vogelaar 

 

It worked!

 

Thank you.