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

 

excel
Formulas and Functions

3 Replies

  • Olufemi7's avatar
    Olufemi7
    Iron Contributor
    Jan 22, 2026

    Hello JoseJavier4​, 

    Summary Your #NAME? error with PROMEDIO inside AGRUPARPOR (GROUPBY) is not a formula syntax problem. Microsoft confirms that GROUPBY supports aggregation functions like SUM, AVERAGE, and PRODUCT. The issue is workbook-specific, usually caused by corruption, hidden name conflicts, or Excel misinterpreting the Spanish function name.

    Official Documentation English: https://support.microsoft.com/en-us/office/groupby-function-5e08ae8c-6800-4b72-b623-c41773611505
    Spanish: https://support.microsoft.com/es-es/office/funci%C3%B3n-agruparpor-5e08ae8c-6800-4b72-b623-c41773611505 

    Why the Error Happens

    • Workbook corruption or compatibility mode.
    • Language mismatch (Excel failing to map AVERAGE ↔ PROMEDIO).
    • Hidden name conflicts (Excel treating Promedio as a custom name).

    Fixes That Work

    1. Wrap in LAMBDA =AGRUPARPOR(FF16:FF22, FG16:FG22, LAMBDA(x, PROMEDIO(x)))
    2. Define a Named Function in Name Manager Name: Promedio Refers to: =LAMBDA(x, PROMEDIO(x)) Then use: =AGRUPARPOR(FF16:FF22, FG16:FG22, Promedio)
    3. Check Language Settings File > Options > Language → Ensure Spanish is set as the editing language.
    4. Rebuild the Workbook Copy data and formulas into a new blank workbook and re-enter formulas manually.
    5. Check for Hidden Names Formulas > Name Manager → Look for Promedio → Delete if found. If nothing shows, save the workbook as .xlsx and reopen to flush hidden names.

    Bottom Line PROMEDIO is supported in AGRUPARPOR. If it fails only in one workbook, the cause is corruption or hidden name conflicts. Wrapping in LAMBDA, checking Name Manager, or recreating the workbook usually resolves the issue.

     “According to Microsoft Support, PROMEDIO is fully supported in AGRUPARPOR. If you’re seeing #NAME? only in one workbook, it’s likely due to corruption or hidden names. Use Name Manager to check for conflicts, wrap PROMEDIO in LAMBDA, or rebuild the workbook to fix it.”




Resources