Give a Range Between Two Specific Texts instead of two Cells

Status
Not open for further replies.

Unexpc

Active Member
Joined
Nov 12, 2020
Messages
314
Office Version
  1. 2019
Platform
  1. Windows
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
1Cutomer ADateFNAGBGACBC
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
Joined
Jun 12, 2014
Messages
56,883
Office Version
  1. 365
Platform
  1. Windows
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.

In relation to your question here, I have closed this thread so please continue in the linked thread.
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top