Forum Discussion
PIVOTBY function: SUM turns into "_xleta.SUM"
You can use
LAMBDA(x,SUM(x))
in english Excel instead of only
SUM
I experience the same problem in Excel online if i use only SUMME or MITTELWERT or ZEILEN in german Excel.
The "_xleta." doesn't appear anymore if i use LAMBDA(x;SUMME(x)) or LAMBDA(x;MITTELWERT(x)) or LAMBDA(x;ZEILEN(x)).....
This means that if i apply SUMME or MITTELWERT or ZEILEN in german Excel "_xleta.SUM" or "_xleta.AVERAGE" or "_xleta.ROWS" (in english) is returned from time to time.
Unfortunately i don't know why this happens with SUM (SUMME) or AVERAGE (MITTELWERT) or ROWS (ZEILEN).....
In spanish Excel you can use LAMBDA(x;SUMA(x)), in french Excel LAMBDA(x;SOMME(x)), in hungarian Excel LAMBDA(x;SZUM(x)) ....
- fArn_25Aug 19, 2025Copper Contributor
Thank you both for the quick reply, the "LAMBDA" solution works.
Maybe it'll be fixed by MS someday...
Best regards