ETA Reduced Lambda
This is often abbreviated to "Eta Lambda".
This refers to a simplified syntax for entering simply types of Lambda formula.
Here is an example using the BYROW function and the SUM function.
=BYROW(array,LAMBDA(x,SUM(x)))
'can now be abbreviated to
=BYROW(array,SUM)
Here is an example using the BYROW function and the AVERAGE function.
=BYROW(array,LAMBDA(x,AVERAGE(x)))
'can now be abbreviated to
=BYROW(array,AVERAGE)
Example
The table shows 4 cities along the top and 6 months down the side.
If we want to average the four columns we could enter the AVERAGE function into cell "H3" and drag it down.
![]() |
This works well although it requires 2 steps and has added 6 functions to the worksheet.
![]() |
Using the BYROW function this can be achieved in one step.
In cell "H3" add the "BYROW" function instead and use this formula.
This formula is using the "eta reduced lamdba" syntax.
=BYROW(C4:F9,AVERAGE)
![]() |
Here is the same formula but without the "eta reduced" syntax.
=BYROW(C4:F9,LAMBDA(x,AVERAGE(x)))
![]() |
More Information
link - techcommunity.microsoft.com/blog/excelblog/new-aggregation-functions-groupby-and-pivotby/3965765
link - spreadsheetweb.com/exploring-eta-lambda-in-excel-a-comprehensive-and-detailed-guide-with-examples/
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext