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

nnn

Microsoft Excel Tips and Tricks

nIn 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.nnnn

Credit Chester Tugwell

n