Monthly Budget Organize Categories by Amount Spent

Google Sheets
, ,
1

Good morning,

I am trying to modify the “Monthly Budget” sheet to organize the specific categories by “actual amount spent” vs alphabetical order. Any way to accomplish this?

Thank you!

Colin

2

Try replacing the formula in Q16 with the following:

={query(
   {INDIRECT(K21),INDIRECT(K20),INDIRECT(K19),INDIRECT(K22),ARRAYFORMULA(XLOOKUP(INDIRECT(K19),V16:V,W16:W,0,0,1))},
   "select Col1, Col2, Col3 where Col1 = 'Income' and Col4 <> 'Hide' order by Col2 asc, Col5 desc",0);
  query(
   {INDIRECT(K21),INDIRECT(K20),INDIRECT(K19),INDIRECT(K22),ARRAYFORMULA(XLOOKUP(INDIRECT(K19),V16:V,W16:W,0,0,1))},
   "select Col1, Col2, Col3 where Col1 = 'Expense' and Col4 <> 'Hide' order by Col2 asc, Col5 asc",0)}

(You’ll need to unhide the columns to the right of column I to find cell Q16.)

2 Likes
3

If you want to restore the original formula in Q16:

=sort(filter({INDIRECT(K21),INDIRECT(K20),INDIRECT(K19)},INDIRECT(K21)<>"Transfer",INDIRECT(K22)<>"Hide"),1,false,2,true,3,true)
4

@rhowell - Thank you very much for the quick response. It worked flawlessly.

Thank you!

1 Like