Here we have a suite of functions that are 'row-aware' which means they know which array row they are next to. This eliminates the need to first select an array row with CHOOSEROWS().
The first function in this suite is ProcessRowλ. ProcessRowλ is extremely versatile because it is a LAMBDA helper function like BYCOL in that it can apply many of Excel's functions or a LAMBDA we create to each element in the array row.
The other functions work identically but fix the function they apply which makes them very simple to use.
NOTE! If you need one function to process all rows see the Array Aware Suite.
ProcessRowλ( Array, [Function] )
Array
(Required) The range this function is next to.
Function
(Optional) An Excel function or LAMBDA formula to process the array's row. This defaults to SUM().
The following functions all share the same syntax: SumRλ, AvgRλ, MinRλ, MaxRλ, AndRλ, OrRλ
SumRλ( Array )
Array
(Required) The range this function is next to.
When ProcessRowλ is placed in the same row as an array's row, it applies its function, in this case, STDEV.P, to that row. SumRλ, AvgRλ, MinRλ, MaxRλ, AndRλ, OrRλ do the same thing but they are restricted to the function they are named after.