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 # ...
ThioJoe demonstrates 10 hidden Excel features that can make working with spreadsheets easier. The madness of George Will: Last lonely never-Trumper forges on ...
Dubbed the "LeBron James of Excel spreadsheets", Galway born and Waterford raised Diarmuid is now the world's best worksheet ...
This project is a port of the excel-formula library to ES6. It contains a set of functions that can be used to pretty print Excel formulas and convert them into JavaScript, C# or Python code.