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
[Solved] SUMIF() gives error 510
[Solved] SUMIF() gives error 510
Last edited by Hagar Delest on Sat Jul 17, 2021 11:45 pm, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
open office 4.1.10 on windows 10
Re: sumif 510er
Try changing your formula like this.
=SOMMA.SE('lista movimenti conto'.H19:H325;">0")
=SOMMA.SE('lista movimenti conto'.H19:H325;">0")
openoffice 4.1.6 - Windows 10