If you decide to spill the results, you can then use the spilled range operator (#) to perform a calculation on the spilled ...

Have you ever thought of the humble SUM function as a secret weapon for advanced analytics? Most Excel users see it as a basic tool for adding numbers, but what if I told you it could do so much more?

You can use SUMIF in Google Sheets to add numbers together that are associated with a date range, specific text, or meet a numeric criterion. Here's everything you need to know to use the SUMIF ...