[Solved] SUMIF() gives error 510

[dogol]

hi every one this is my first time posting on this forum! i apologize if my question is open somewhere else but i couldn't find it (i tried)

anyway i cant seem to make work the sumif function..

i have a column of positive and negative numbers and im trying to add them separately.

this is my formula =SOMMA.SE('lista movimenti conto'.H19:H325;>0)

but it gives me the 510er

pls help

[gpgrego]

Try changing your formula like this.

=SOMMA.SE('lista movimenti conto'.H19:H325;">0")

[dogol]

thank you!!