BYROW and BYCOL: One Formula for Every Row or Column
This lesson is part of the course
In this lesson
You summarise Alder & Finch's H2 store sales with BYROW (total and range per store) and BYCOL (total per month and stores that hit the target), each as one spilling formula.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- LET: Name Your Intermediate Results for Readable, Faster Formulas Locked
- LAMBDA Basics: Parameters, a Calculation and Calling It Inline Locked
- Named LAMBDAs: TaxPrice, MarginPct and Your Own Workbook Functions Locked
- BYROW and BYCOL: One Formula for Every Row or Column Locked
- MAP: Your Own Logic for Every Element, Even with AND and OR Locked
- REDUCE and SCAN: Running Totals, Compounding and Final Balances Locked
- MAKEARRAY: Multiplication Tables, Rotas and Payment Schedules Locked
- Capstone: Refactor a Nested Commission Formula into LET and LAMBDA Locked