Spreadsheet: 685247d1593844152-sumifs-problem-sum-by-column-header-aligw
Sheet: Sheet7

 |  | Q2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Q3 |  |  |  |  |  |  |  |  |  |  |  |  | Q4
Expense Type | Name | 2020-07-01 00:00:00 | 2020-07-08 00:00:00 | 2020-07-15 00:00:00 | 2020-07-22 00:00:00 | 2020-07-29 00:00:00 | 2020-08-05 00:00:00 | 2020-08-12 00:00:00 | 2020-08-19 00:00:00 | 2020-08-26 00:00:00 | 2020-09-02 00:00:00 | 2020-09-09 00:00:00 | 2020-09-16 00:00:00 | 2020-09-23 00:00:00 | 2020-09-30 00:00:00 | 2020-10-07 00:00:00 | 2020-10-14 00:00:00 | 2020-10-21 00:00:00 | 2020-10-28 00:00:00 | 2020-11-04 00:00:00 | 2020-11-11 00:00:00 | 2020-11-18 00:00:00 | 2020-11-25 00:00:00 | 2020-12-02 00:00:00 | 2020-12-09 00:00:00 | 2020-12-16 00:00:00 | 2020-12-23 00:00:00 | 2020-12-30 00:00:00 | 2021-01-06 00:00:00 | 2021-01-13 00:00:00 | 2021-01-20 00:00:00 | 2021-01-27 00:00:00 | 2021-02-03 00:00:00 | 2021-02-10 00:00:00 | 2021-02-17 00:00:00 | 2021-02-24 00:00:00 | 2021-03-03 00:00:00 | 2021-03-10 00:00:00 | 2021-03-17 00:00:00 | 2021-03-24 00:00:00 | 2021-03-31 00:00:00 | 2021-04-07 00:00:00
Fixed Rate Expenses
Rent | Rent A | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275
Utility | [NAME] | -30.13 | 0 | 0 | 0 | -30.13 | 0 | 0 | 0 | -30.13 | 0 | 0 | 0 | 0 | -30.13 | 0 | 0 | 0 | -30.13 | 0 | 0 | 0 | -30.13 | 0 | 0 | 0 | 0 | -30.13 | 0 | 0 | 0 | -30.13 | 0 | 0 | 0 | -30.13 | 0 | 0 | 0 | 0 | -30.13
Subscription | Subscription A | 0 | 0 | 0 | -19.99 | 0 | 0 | 0 | -19.99 | 0 | 0 | 0 | 0 | -19.99 | 0 | 0 | 0 | -19.99 | 0 | 0 | 0 | -19.99 | 0 | 0 | 0 | 0 | -19.99 | 0 | 0 | 0 | -19.99 | 0 | 0 | 0 | -19.99 | 0 | 0 | 0 | -19.99 | 0 | 0
Subscription | Subscription B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -89.99 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Insurance | Insurance A | 0 | -110.26 | 0 | 0 | 0 | -110.26 | 0 | 0 | 0 | 0 | -110.26 | 0 | 0 | 0 | -110.26 | 0 | 0 | 0 | 0 | -110.26 | 0 | 0 | 0 | -110.26 | 0 | 0 | 0 | -110.26 | 0 | 0 | 0 | 0 | -110.26 | 0 | 0 | 0 | -110.26 | 0 | 0 | 0
Variable Rate Expenses
Food | Food A | 0 | -50 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -50 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -50 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Food | Food B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -50 | -50 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -50 | 0 | -50 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0
Travel | Travel | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Utilities | [NAME] | 0 | 0 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Utilities | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | -50 | -50 | 0 | 0 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | -50 | -50 | 0 | 0 | 0 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | -50 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Others | Others A | -50 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -50 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Others | Others B | -16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Income
Income | Salary A | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0 | 2000 | 0
 | Salary B | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 1