Forum Discussion
JoseJavier4
Jan 22, 2026Occasional Reader
AVERAGE reduced lambda on GROUPBY or BYROW formulas not working on specific workbook.
Currently using excel with spanish formulas. When using GROUPBY formula, i can use SUM, PRODUCT, LAMBDA, however AVERAGE (PROMEDIO) won't work on a specific workbook which previously has a lot of GROUPBYs that work properly.
When I update the previously working formula, it now returns NAME error and PROMEDIO turns into Promedio.
Inserting the function looks like this:
I have no custom name called Promedio. This same GROUPBY formula works in different workbooks.
Help would be appreciated. Best regards
2 Replies
- OliverScheurichGold Contributor
Does it work if you replace
PROMEDIO
by
LAMBDA(x,PROMEDIO(x))
?