Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,538
- Office Version
- 365
- 2013
- Platform
- Windows
Is it possible to find expected SUM from one sheet to another?
Below Sheet Blalock2 amounts in column B have may have SUM from Blalock1
For Example Amount in cell B3 is 5,498.35 so I want to find smaller amounts from Blalock1 which totals 5,498.35
Sheet Blalock1
Below Sheet Blalock2 amounts in column B have may have SUM from Blalock1
For Example Amount in cell B3 is 5,498.35 so I want to find smaller amounts from Blalock1 which totals 5,498.35
Blalock2.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | DATE 2 | SPENT 2 | ||
2 | 1/1/2021 | 408.41 | ||
3 | 1/1/2021 | 5,498.35 | ||
4 | 1/1/2021 | 7,441.35 | ||
5 | 1/1/2021 | 8,252.56 | ||
6 | 1/1/2021 | 11,387.92 | ||
7 | 1/1/2021 | 14,378.45 | ||
8 | 1/15/2021 | 7,188.82 | ||
9 | 1/15/2021 | 1,156.88 | ||
10 | 1/15/2021 | 2,279.66 | ||
11 | 1/15/2021 | 8,329.83 | ||
12 | 1/15/2021 | 4,860.35 | ||
13 | 1/15/2021 | 9,677.81 | ||
14 | 1/15/2021 | 7,084.41 | ||
15 | 1/15/2021 | 10,196.50 | ||
16 | 1/22/2021 | 4,511.33 | ||
17 | 1/22/2021 | 6,298.02 | ||
18 | 1/22/2021 | 14,418.90 | ||
19 | 1/22/2021 | 18,232.86 | ||
20 | 1/23/2021 | 51.29 | ||
21 | 1/30/2021 | 5,957.85 | ||
22 | 1/30/2021 | 7,900.31 | ||
23 | 1/30/2021 | 19,177.32 | ||
24 | 1/30/2021 | 8,337.11 | ||
25 | 1/30/2021 | 8,535.07 | ||
26 | 1/30/2021 | 7,228.74 | ||
27 | 1/30/2021 | 12,137.10 | ||
28 | 1/30/2021 | 12,669.43 | ||
29 | 1/30/2021 | 5,792.62 | ||
Blalock2 |
Sheet Blalock1
Blalock1.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Date 1 | Spent 1 | ||
2 | 01/13/2021 | 21.44 | ||
3 | 01/13/2021 | 72.01 | ||
4 | 01/13/2021 | 76.11 | ||
5 | 01/13/2021 | 76.11 | ||
6 | 01/13/2021 | 81.36 | ||
7 | 01/20/2021 | 149.50 | ||
8 | 01/13/2021 | 151.23 | ||
9 | 01/20/2021 | 187.30 | ||
10 | 01/20/2021 | 216.47 | ||
11 | 01/13/2021 | 232.77 | ||
12 | 01/13/2021 | 233.18 | ||
13 | 01/20/2021 | 243.55 | ||
14 | 01/13/2021 | 294.05 | ||
15 | 01/13/2021 | 305.03 | ||
16 | 01/20/2021 | 348.72 | ||
17 | 01/20/2021 | 413.04 | ||
18 | 01/20/2021 | 517.28 | ||
19 | 01/13/2021 | 518.55 | ||
20 | 01/20/2021 | 552.15 | ||
21 | 01/20/2021 | 627.72 | ||
22 | 01/20/2021 | 664.43 | ||
23 | 01/20/2021 | 789.07 | ||
24 | 01/13/2021 | 1,104.97 | ||
25 | 01/13/2021 | 1,197.34 | ||
26 | 01/20/2021 | 1,711.07 | ||
27 | 01/13/2021 | 3,369.88 | ||
28 | 01/13/2021 | 4,306.61 | ||
29 | 12/29/2020 | 4,356.95 | ||
30 | 01/20/2021 | 4,615.76 | ||
31 | 01/13/2021 | 4,791.87 | ||
32 | 01/13/2021 | 4,838.91 | ||
33 | 12/30/2020 | 5,677.67 | ||
34 | 01/20/2021 | 5,692.37 | ||
35 | 01/13/2021 | 5,897.00 | ||
36 | 12/30/2020 | 6,406.86 | ||
37 | 01/13/2021 | 6,413.22 | ||
38 | 01/13/2021 | 6,851.58 | ||
39 | 01/13/2021 | 6,883.79 | ||
40 | 12/30/2020 | 7,129.34 | ||
41 | 01/13/2021 | 8,353.83 | ||
42 | 01/13/2021 | 9,010.17 | ||
43 | 01/20/2021 | 9,222.04 | ||
44 | 01/13/2021 | 9,605.80 | ||
45 | 12/31/2020 | 10,970.97 | ||
46 | 01/20/2021 | 14,526.44 | ||
Sheet1 |