Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/07/Spill-Non-Spillable-Functions.xlsx

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.

The AND & OR functions also do not spill by default, but with the MAP functions you can make them spill.

This tutorial assumes you know how to use the LAMBDA function. If you are not sure how this function works or need a reminder, please watch: https://youtu.be/yqxE7-gDauw

00:00 Introduction
00:25 Spill SUM with BYROW and LAMBDA
01:42 Spill MEDIAN with BYCOL and LAMBDA
02:40 Spill COUNTIF with BYROW and LAMBDA
03:58 Spill OR with MAP and LAMBDA (also works for AND)




#exceltips #exceltutorial #excel365