Pull in sum values for a specific date range

[ngann]

i’m trying to pull in all values in a specified date range. The data is on a separate tab and delineated by discrete dates. I need to sum all the dollars in a specific range. Please let me know if you have any ideas. Thanksb

 

[Special-K99]

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[ngann]

	1/1/2019	1/10/2019	1/20/2019	2/25/2019	3/12/2019
1
2
3
4
5

<colgroup><col width="68" style="width: 51pt;" span="2"> <col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2355;" span="4"> <tbody> </tbody>

Index	Date	$
1	1/1/2019	$ 5.00
1	3/14/2019	$ 10.00
1	2/17/2019	$ 7.00
1	2/2/2019	$ 20.00
2	1/1/2019	$ 34.00
2	3/14/2019	$ 5.00
2	2/17/2019	$ 9.00
2	2/2/2019	$ 17.00
3	1/1/2019	$ 22.00
3	3/14/2019	$ 41.00
5	2/17/2019	$ 58.00
5	2/2/2019	$ 2.00
4	3/31/2019	$ 18.00
4	2/27/2019	$ 9.00

<colgroup><col width="68" style="width: 51pt;"> <col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2355;"> <col width="68" style="width: 51pt;"> <tbody> </tbody>

 

[ngann]

Above is a mockup of the two sheets I will be using. Each of these tables are on separate tabs. I am trying to have excel sum the $'s if the index matches and the dates are equal to or less than the date called out in row 1 on the first table.

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F
1		01/01/2019	10/01/2019	20/01/2019	25/02/2019	12/03/2019
2	1	5	5	5	32	32
3	2	34	34	34	60	60
4	3	22	22	22	22	22
5	4	0	0	0	0	9
6	5	0	0	0	60	60
Sheet2

Cell Formulas
Range	Formula
B2	=SUMIFS(Sheet1!$C$2:$C$15,Sheet1!$A$2:$A$15,$A2,Sheet1!$B$2:$B$15,"<="&B$1)

Excel 2013/2016
	A	B	C
1	Index	Date	$
2	1	01/01/2019	$ 5.00
3	1	14/03/2019	$10.00
4	1	17/02/2019	$ 7.00
5	1	02/02/2019	$20.00
6	2	01/01/2019	$34.00
7	2	14/03/2019	$ 5.00
8	2	17/02/2019	$ 9.00
9	2	02/02/2019	$17.00
10	3	01/01/2019	$22.00
11	3	14/03/2019	$41.00
12	5	17/02/2019	$58.00
13	5	02/02/2019	$ 2.00
14	4	31/03/2019	$18.00
15	4	27/02/2019	$ 9.00
Sheet1