Forum Discussion

JoseJavier4's avatar
JoseJavier4
Occasional Reader
Jan 22, 2026

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

Resources