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 # ...

When I started using Microsoft Excel, my spreadsheets were a mess, and I wasted hours trying to make them look professional. If you're struggling with manual formatting, these six simple tips are the ...