[Issue] SUMIF with multiple conditions

[wojmo]

Edit: Split from [Solved] SUMIF with multiple conditions because that topic is solved so you need your own. If you had the same problem you could use the same solution. Please do not post in another's topic unless you are helping to solve their problem for them.

I need to sum up all numbers in one column higher then -100 and less then 0.
I tried this: =SUMIFS( I2:I118 ; I2:I118, ">" -100 ; I2:I118, "<" 0)
Where's the error?

[RusselB]

Change the last parameter separator from a comma to a semicolon

[wojmo]

Thank you Sir,
It did work when I changed both commas after range1 and range2 to semicolon. Does that mean an error in OO prompts?

screenshot 2022-10-10 112040.jpg (13.83 KiB) Viewed 1788 times

[RoryOF]

OpenOffice uses ; (semicolon) as the delimiter. Some other spreadsheets use , (comma). Simply a difference in design.

[wojmo]

The above screenshot shows OpenOffice prompt...

[RusselB]

That is an error in the prompt balloon.

[robleyd]

It has been reported as a bug.