Array formula not working [closed]
We have a card playing club with 6 tournaments per year. The rank in each tournament is entered into the attached table. (How to attach it? Searching "attach image" provides no answer). The two worst of the six results are dropped and only four are counted for the final Points score in column C. The two grey shaded results for each player are omitted.
The formula in Excel to do this used to be {=SUM(SMALL(D2:I2,{1,2,3,4}))} entered with Ctrl-Shift-Enter. Have copied this formula into Libre Office Calc, but it's not working. Have tried many variations after studying the Array formula guidelines, but none worked. What is the correct formula to calculate the best (lowest) four results out of six for each player? Once it is entered in the first row, can it be pulled down to the end of the table? Are there basic differences between Excel and Libre formulas? Thank you.
I cannot confirm the statement. Assuming your settings is accepting the comma as parameter delimiter and as either the column delimiter or the row delimiter for inline arrays, the formula should work. It does for me in LibO Calc V5.2.2. in my 'German (Germany)' locale with the semicolon in bot tze mentioned roles.
Is there a way to verify whether my settings accept the comma? Have also tried with semi-colons instead of commas, but not working either.
Have now copied the first 6 records from the main table and pasted them into a new sheet, and there the formula works. But the same formula doesn't work in the original sheet. When entering Ctrl-Shift-Enter, the curly brackets don't appear. How to change the settings?