kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 951
- Office Version
- 365
HI,
I have the following table which records actual expenses:
In the second table as below, I have the forecasted expenses:
In the following cell , I am trying to summarize the difference between the actual expenses as of Sept 13 and the balance of the expense from the forecasted expenses. The correct answer is 920 which is the balance of the expense between Stp 14 to Sept 21 since the we have actual expense until Sept 13. Is there a way to build a formula to calculate this ? Appreciate all the help.
I have the following table which records actual expenses:
Book1 | |||||
---|---|---|---|---|---|
B | C | D | |||
5 | Date | Expense | Amount | ||
6 | Sunday, 3 September, 2023 | Breakfast | 50 | ||
7 | Monday, 4 September, 2023 | Dinner | 30 | ||
8 | Tuesday, 5 September, 2023 | Travel | 50 | ||
9 | Wednesday, 6 September, 2023 | Breakfast | 60 | ||
10 | Thursday, 7 September, 2023 | Travel | 30 | ||
11 | Friday, 8 September, 2023 | Travel | 25 | ||
12 | Saturday, 9 September, 2023 | Book | 80 | ||
13 | Sunday, 10 September, 2023 | Book | 10 | ||
14 | Monday, 11 September, 2023 | Travel | 15 | ||
15 | Tuesday, 12 September, 2023 | Book | 25 | ||
16 | Wednesday, 13 September, 2023 | Donation | 26 | ||
Sheet1 |
In the second table as below, I have the forecasted expenses:
Book1 | |||||
---|---|---|---|---|---|
F | G | H | |||
5 | Date | Expense | Amount | ||
6 | Sunday, 3 September, 2023 | Breakfast | 50 | ||
7 | Monday, 4 September, 2023 | Dinner | 100 | ||
8 | Tuesday, 5 September, 2023 | Travel | 50 | ||
9 | Wednesday, 6 September, 2023 | Breakfast | 60 | ||
10 | Thursday, 7 September, 2023 | Travel | 200 | ||
11 | Friday, 8 September, 2023 | Travel | 25 | ||
12 | Saturday, 9 September, 2023 | Book | 80 | ||
13 | Sunday, 10 September, 2023 | Book | 300 | ||
14 | Monday, 11 September, 2023 | Travel | 15 | ||
15 | Tuesday, 12 September, 2023 | Book | 200 | ||
16 | Wednesday, 13 September, 2023 | Donation | 50 | ||
17 | Thursday, 14 September, 2023 | Travel | 200 | ||
18 | Friday, 15 September, 2023 | Travel | 25 | ||
19 | Saturday, 16 September, 2023 | Book | 80 | ||
20 | Sunday, 17 September, 2023 | Book | 300 | ||
21 | Monday, 18 September, 2023 | Travel | 15 | ||
22 | Tuesday, 19 September, 2023 | Book | 200 | ||
23 | Wednesday, 20 September, 2023 | Donation | 50 | ||
24 | Thursday, 21 September, 2023 | Donation | 50 | ||
Sheet1 |
In the following cell , I am trying to summarize the difference between the actual expenses as of Sept 13 and the balance of the expense from the forecasted expenses. The correct answer is 920 which is the balance of the expense between Stp 14 to Sept 21 since the we have actual expense until Sept 13. Is there a way to build a formula to calculate this ? Appreciate all the help.
Total Balance Forecasted Expense | 920 |