Use BYROW, BYCOL & MAP to Spill Non-Spillable Functions In Excel | Spill SUM, COUNTIF & OR

Microsoft Excel Tips and Tricks

In this Microsoft Excel video tutorial I demonstrate how to spill non-spillable functions. Aggregate functions such as SUM, AVERAGE, MIN, MAX, COUNT and MEDIAN don’t spill by default – to make them spill you need to use BYROW and BYCOL.

Credit Chester Tugwell