There might be some numbers you're missing when summing it up.
BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.