Hi guys
i asked this question in 3 post(SUM in changeable range between two texts) but i still does not solved for me.
i want this:
Sheet 1
Sheet 2
i asked this question in 3 post(SUM in changeable range between two texts) but i still does not solved for me.
i want this:
Sheet 1
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Name | Date | Sum 1 | Sum 2 | ||
2 | Customer A | Last Date Of Customer A | Sum D:E Start at Customer A and End before Customer B For Example Until Last Row Added (15) = 764 | Sum F:G Start at Customer A and End before Customer B | ||
3 | Customer B | Last Date Of Customer B | Sum D:E Start at Customer B and End before Customer C For Example Until Last Row Added (31) = 2184 | Sum F:G Start at Customer B and End before Customer C | ||
4 | ||||||
5 | Last Formula I Have | LOOKUP(2,1/(Sheet2!B:B<>""),Sheet2!B:B) | SUM(Sheet2!D3:D1048576)+SUM(Sheet2!E3:E1048576) or SUM(Sheet2!D3:E1048576) | SUM(Sheet2!F3:G1048576) | ||
6 | This Formulas was for every sheet i create but i want in one sheet and between two customer | |||||
Sheet1 |
Sheet 2
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Cutomer A | Date | FN | AG | BG | AC | BC | ||
2 | 1 | 200101 | 1000 | 56 | 5656 | ||||
3 | 2 | 200102 | 1001 | 47 | |||||
4 | 3 | 200103 | 1002 | 58 | |||||
5 | 4 | 200104 | 1003 | 22 | |||||
6 | 5 | 200105 | 1004 | 34 | 888 | ||||
7 | 6 | 200106 | 1005 | 56 | |||||
8 | 7 | 200107 | 1006 | 55 | |||||
9 | 8 | 200108 | 1007 | 78 | 5454 | ||||
10 | 9 | 200109 | 1008 | 61 | |||||
11 | 10 | 200110 | 1009 | 32 | |||||
12 | 11 | 200111 | 1010 | 55 | 5656 | ||||
13 | 12 | 200112 | 1011 | 66 | |||||
14 | 13 | 200113 | 1012 | 88 | |||||
15 | 14 | 200114 | 1013 | 56 | 8888 | ||||
16 | |||||||||
17 | Customer B | Date | FN | AG | BG | AC | BC | ||
18 | 1 | 200101 | 1000 | 88 | |||||
19 | 2 | 200102 | 1001 | 666 | |||||
20 | 3 | 200103 | 1002 | 33 | |||||
21 | 4 | 200104 | 1003 | 25 | |||||
22 | 5 | 200105 | 1004 | 645 | |||||
23 | 6 | 200106 | 1005 | 221 | 56565 | ||||
24 | 7 | 200107 | 1006 | 65 | |||||
25 | 8 | 200108 | 1007 | 56 | |||||
26 | 9 | 200109 | 1008 | 54 | |||||
27 | 10 | 200110 | 1009 | 55 | |||||
28 | 11 | 200111 | 1010 | 55 | |||||
29 | 12 | 200112 | 1011 | 66 | |||||
30 | 13 | 200113 | 1012 | 89 | |||||
31 | 14 | 200114 | 1013 | 66 | 56565 | ||||
32 | |||||||||
33 | Customer C | ||||||||
34 | . | ||||||||
35 | . | ||||||||
36 | . | ||||||||
37 | Other Customers | ||||||||
Sheet2 |