If you decide to spill the results, you can then use the spilled range operator (#) to perform a calculation on the spilled range. Simply reference the first cell of the spilled range with a # ...

Q. How do I spill formulas in Excel? A. Spilling is a feature available in Excel 365 and later versions. With spilling, you can create a formula in one cell, and that formula will then spill over into ...