Err:539
is unsupported inline array content. This should direct you to your SUMIF
function usage.
Second argument is Criteria. In your formula, you try to express a “combined” criterion as a concatenation (&
operator) between scalar string "<="
and range A4:A1109
. This does not make sense.
The second error is: there is no SORT
built-in function in Calc.
Finally, conversion may have messed up the argument separators. It depends on the locale, so I can’t assert if ,
is the right separator for you.
EDIT 1
As you seem too lazy to learn the basics of Calc (this is quite easy when you already know other spreadsheet application; just download the Calc Guide and read it), here is the correct formula:
=SUMIF(A4:A1109;"<="&$J$3;B4:B1109)
There are yet other strange function calls in J3, L3 and M3. I let you adapt them as an exercise because I dont know and I have no time to guess what these cells should display.
Moreover the formulas in J3:M3 play nasty tricks with the locale. E.g. date format is hard-coded to US style which upset me when I tried to understand why the result was not what I read in the H-column. My locale being different, I lost a lot of time thinking I didn’t use SUMIF
correctly. A useful spreadsheet should not create confusion, using two formattings for the same type of data: either date are locale or they are forced to some conventions but should never change across cells.
(EDIT 2 only removed misspellings and typos)
To show the community your question has been answered, click the ✓ next to the correct answer, and “upvote” by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!
In case you need clarification, edit your question (not an answer which is reserved for solutions) or comment the relevant answer.