How to sum array resulting from array formula

[soaser]

I have an XLOOKUP that I can evaluate in array mode and it will return what I want. However, to avoid scratch cells I would just like to take the resulting array and sum it inline. See the attached sheet
how_to_sum.ods (11.4 KB)

Conceptually, it’s the same as the example “create an array formula that calculates a single result” from this excel help:

Create an array formula - Microsoft Support

though of course, that particular example would be fine with sumproduct

I can’t find the same in the libreoffice help, but maybe I’m just blind. I can get it to work with inline arrays: =sum({1;2;3}) works, but I want it for a nested formula

[soaser]

I tried to do it in excel and then import it, but this sheet does not import correctly (xlookup becomes all lowercase) but even if I fix it to be uppercase it till gives an error.
Untitled spreadsheet(1).xlsx (5.0 KB)

[mariosv]

LibreOffice Release Notes 24.8 New_functions