# Give a Range Between Two Specific Texts instead of two Cells

Status
Not open for further replies.

#### Unexpc

##### Active Member
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
Book1
ABCD
1NameDateSum 1Sum 2
2Customer ALast Date Of Customer ASum D:E Start at Customer A and End before Customer B For Example Until Last Row Added (15) = 764Sum F:G Start at Customer A and End before Customer B
3Customer BLast Date Of Customer BSum D:E Start at Customer B and End before Customer C For Example Until Last Row Added (31) = 2184Sum F:G Start at Customer B and End before Customer C
4
5Last Formula I HaveLOOKUP(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)
6This Formulas was for every sheet i create but i want in one sheet and between two customer
Sheet1

Sheet 2
Book1
ABCDEFG
212001011000565656
32200102100147
43200103100258
54200104100322
65200105100434888
76200106100556
87200107100655
982001081007785454
109200109100861
1110200110100932
12112001111010555656
1312200112101166
1413200113101288
15142001141013568888
16
17Customer BDateFNAGBGACBC
181200101100088
1922001021001666
203200103100233
214200104100325
2252001051004645
236200106100522156565
247200107100665
258200108100756
269200109100854
2710200110100955
2811200111101055
2912200112101166
3013200113101289
311420011410136656565
32
33Customer C
34.
35.
36.
37Other Customers
Sheet2

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

#### Fluff

##### MrExcel MVP, Moderator
Duplicate to: SUM in changeable range between two texts

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

Status
Not open for further replies.

Replies
2
Views
73
Replies
26
Views
728
Replies
1
Views
434
Replies
3
Views
399
Replies
4
Views
4K

1,130,170
Messages
5,640,567
Members
417,151
Latest member
ChickenTenderer

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back