Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Sorry, maybe I entered my answers in the wrong place.
Under Separators the Function and Array column show a comma, and the array row a semi-colon. The same settings for both the original and the test table, where one works and the other not.

Sorry, maybe I entered my answers in the wrong place.
Under Separators the Function and Array column show a comma, and the array row a semi-colon. The same settings for both the original and the test table, where one works and the other not.

The formula {=SUM(SMALL(D2:I2;ROW(INDIRECT("A1:A4"))))} is not working. When entering with Ctrl-Shift-Emter, the curly brackets don't show.

Sorry, maybe I entered my answers in the wrong place.
Under Separators the Function and Array column show a comma, and the array row a semi-colon. The same settings for both the original and the test table, where one works and the other not.

The formula {=SUM(SMALL(D2:I2;ROW(INDIRECT("A1:A4"))))} is not working. When entering with Ctrl-Shift-Emter, the curly brackets don't show.

The same is true for the original formula. In the test table the formula works. But when copying that formula and pasting it back to the original table, the curly brackets don't appear after enter with Ctrl-Shift-Emter. What can prevent those brackets to show?