I'm creating a cashflow management sheets that can count all my expenses and incomes, also to track the usage of my budgets. I can categorize each expenses by selecting from a list of options. My question is, can I get sum of every expenses (in this example from column C and G) and put in in column Used based on each categories I select on column D and H?

enter image description here

  • 1
    Welcome to Web Applications. Please show directly in the question the formulas that you have tried.
    – Rubén
    Aug 5 '21 at 18:04

You can aggregate the expenses by category with query() like this:

=query(A3:D, "select D, sum(C) where C is not null group by D", 1)

To do the same with data where there are several similar column groups side by side, use something like this:

=query( { D3:D, C3:C; H4:H, G4:G }, "select Col1, sum(Col2) where Col2 is not null group by Col1", 1 )

To place these results in a mini report side by side with the budgeted figures, use vlookup().

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.