I have tables in a single sheet organized similar to this:

Image of spreadsheet data layout

I want to write a query that can summarize the values of each line item uniquely. For example, total "Labour" across all 5 invoices. I can't seem to get a query to work across tables.

I have a query like so, that works for one instance of a table:

=QUERY(A4:B6, "select A, sum(B) group by A order by A") 

But I can't extrapolate this logic to extend across data like this.

Does anyone have insights into if a QUERY statement can fit this use case?

  • 1
    Welcome to Web Applications. You should "stack" each range first the use the resulting range/array as the first parameter of query. If you need further help, please show what you tried and add a brief description of you search efforts as is suggested in How to Ask. P.S. Usually linking a demo spreadsheet shared with anyone with the link to view only helps to get an specific answer.
    – Rubén
    Aug 20 at 2:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.