Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

As a parameter delimiter the semicolon should be accepted in any locale. The settings for the two delimiters set for use with inline constant arrays you find under > 'Tools' > 'Options' > 'LibreOffice Calc' > ' 'Formula' > 'Separators'.
You also may try {=SUM(SMALL(D2:I2;ROW(INDIRECT("A1:A4"))))} entered for array-evaluation again, where the four consecutive ranks are generated by the ROW function applied to a range spanning from row 1 to row 4.

As a parameter delimiter the semicolon should be accepted in any locale. The settings for the two delimiters set for use with inline constant arrays you find under > 'Tools' > 'Options' > 'LibreOffice Calc' > ' 'Formula' > 'Separators'.
You also may try {=SUM(SMALL(D2:I2;ROW(INDIRECT("A1:A4"))))} entered for array-evaluation again, where the four consecutive ranks are generated by the ROW function applied to a range spanning from row 1 to row 4.

(Editing with respct to the comment below:)
Following your report about the settings both the variants (with comma or with semicolon used for the inline array) should work. The suggestion above should work anyway. I'm stumped.
Please try this attached example which was made with LibO Calc V5.2.2. Both the suggested solutions worked there for me (in columns H, I).