BYROW Function
Yesterday, I covered the new BYCOL function, which allows you to perform calculations on columns in an array. (https://lnkd.in/e5G5xKBd)
Guess what? There’s also a BYROW function! Predictably, it does the same thing for rows instead.
Here’s the syntax:
BYROW (𝗮𝗿𝗿𝗮𝘆, [𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻] )
• 𝗮𝗿𝗿𝗮𝘆 — the array to break down by row.
• [𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻] — 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).