BYROW Function

Yesterday, I covered the new BYCOL function, which allows you to perform calculations on columns in an array.

Guess what? There’s also a BYROW function! Predictably, it does the same thing for rows instead.

Here’s the syntax:

BYROW (array, [function] )

• array — the array to break down by row.
• [function] — a LAMBDA to apply on each row.

Whereas BYCOL calculated monthly totals, BYROW does so for product totals (Example 3).

It also uses conditional logic to find:

• The number of months each product made less than £1,000 (Example 4).
• The products that made less than £15,000 (Example 5).
• The products that had months making more than £2,000 (Example 6).