I am putting together a worksheet to keep track of expenses. I currently have the following source table called "Expenses":
A | B | C | D | |
---|---|---|---|---|
1 | Date | Description | Category | Amount |
2 | 1-Jan | Purchase1 | Cat1 | 1.00 |
3 | 3-Jan | Purchase2 | Cat1 | 2.00 |
4 | 5-Jan | Purchase1 | Cat2 | 3.00 |
5 | 7-Jan | Purchase4 | Cat2 | 4.00 |
And a Summary table:
A | B | |
---|---|---|
1 | Category | Total |
2 | Cat1 | 3.00 |
3 | Cat2 | 7.00 |
The formulas in the Summary table are:
A2: =UNIQUE(Expenses!$C$2:$C$5)
A3: =CONTINUE(A2, 2, 1)
B2: =SUMIF(Expenses!$C$2:$C$5,A2,Expenses!$D$2:$D$5)
B3: =SUMIF(Expenses!$C$2:$C$5,A3,Expenses!$D$2:$D$5)
What I would like to achieve is sorting the Summary table by the value in column B in decreasing order, but I can't figure out how to get the SUMIF() value in array form to use with SORT().
Eventually I hope to have a formula for A2 that looks something like:
=SORT(UNIQUE(Expenses!$C$2:$C$5, ***ARRAY_OF_SUMIF_VALUES***, FALSE)