Book1 | |||||||
---|---|---|---|---|---|---|---|
C | D | E | F | G | |||
1 | Date | Transaction | Payee/Payor | Deposit Payment | Balance | ||
2 | $187,216.21 | ||||||
3 | 1/17/2024 | Checking | Hyundai | $371.80 | $186,844.41 | ||
4 | 1/17/2024 | Commissary | 7411 | $16.89 | $186,827.52 | ||
5 | 1/17/2024 | Travel | 7411 | $867.65 | $185,959.87 | ||
6 | 1/17/2024 | XMAS | 7411 | $95.26 | $185,864.61 | ||
7 | 1/17/2024 | Insurance | 4782 | $405.84 | $185,458.77 | ||
8 | 1/17/2024 | Insurance | USAA | $1,176.08 | $184,282.69 | ||
9 | 1/17/2024 | Insurance | 4782 | $101.10 | $184,181.59 | ||
10 | 1/17/2024 | Checking | 4782 | $430.36 | $183,751.23 | ||
11 | |||||||
12 | |||||||
13 | Checking | 802.16 | |||||
14 | Commissary | 16.89 | |||||
15 | Insurance | 1683.02 | |||||
16 | Travel | 867.65 | |||||
17 | XMAS | 95.26 | |||||
18 | Total | 3464.98 | |||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C13:D18 | C13 | =GROUPBY(D3:D10,F3:F10,SUM) |
Dynamic array formulas. |
wish MS would get around to releasing it to the public!! Long overdue.An alternative with the new function in 365, GroupBy
Book1
C D E F G 1 Date Transaction Payee/Payor Deposit Payment Balance 2 $187,216.21 3 1/17/2024 Checking Hyundai $371.80 $186,844.41 4 1/17/2024 Commissary 7411 $16.89 $186,827.52 5 1/17/2024 Travel 7411 $867.65 $185,959.87 6 1/17/2024 XMAS 7411 $95.26 $185,864.61 7 1/17/2024 Insurance 4782 $405.84 $185,458.77 8 1/17/2024 Insurance USAA $1,176.08 $184,282.69 9 1/17/2024 Insurance 4782 $101.10 $184,181.59 10 1/17/2024 Checking 4782 $430.36 $183,751.23 11 12 13 Checking 802.16 14 Commissary 16.89 15 Insurance 1683.02 16 Travel 867.65 17 XMAS 95.26 18 Total 3464.98 Sheet1
Cell Formulas Range Formula C13:D18 C13 =GROUPBY(D3:D10,F3:F10,SUM) Dynamic array formulas.