This article looks at how to add a total row to tables generated using the Query function in Google Sheets. It’s an interesting use case for array formulas, using the {...} notation, rather than the ArrayFormula notation.
So what the heck does this all mean?
It means we’re going to see how to add a total row like this:
using an array formula of this form:
= { QUERY ; { "TOTAL" , SUM(range) } }Continue reading How to add a total row to a Query Function table in Google Sheets