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]

[TABLE="width: 310"]
<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>[TR]
[TD="width: 68, bgcolor: black"] [/TD]
[TD="width: 68, bgcolor: transparent, align: right"]1/1/2019[/TD]
[TD="width: 69, bgcolor: transparent, align: right"]1/10/2019[/TD]
[TD="width: 69, bgcolor: transparent, align: right"]1/20/2019[/TD]
[TD="width: 69, bgcolor: transparent, align: right"]2/25/2019[/TD]
[TD="width: 69, bgcolor: transparent, align: right"]3/12/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 154"]
<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>[TR]
[TD="width: 68, bgcolor: transparent"]Index[/TD]
[TD="width: 69, bgcolor: transparent"]Date[/TD]
[TD="width: 68, bgcolor: transparent"]$[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]1/1/2019[/TD]
[TD="bgcolor: transparent"] $ 5.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]3/14/2019[/TD]
[TD="bgcolor: transparent"] $ 10.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]2/17/2019[/TD]
[TD="bgcolor: transparent"] $ 7.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]2/2/2019[/TD]
[TD="bgcolor: transparent"] $ 20.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]1/1/2019[/TD]
[TD="bgcolor: transparent"] $ 34.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]3/14/2019[/TD]
[TD="bgcolor: transparent"] $ 5.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]2/17/2019[/TD]
[TD="bgcolor: transparent"] $ 9.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]2/2/2019[/TD]
[TD="bgcolor: transparent"] $ 17.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent, align: right"]1/1/2019[/TD]
[TD="bgcolor: transparent"] $ 22.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent, align: right"]3/14/2019[/TD]
[TD="bgcolor: transparent"] $ 41.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]2/17/2019[/TD]
[TD="bgcolor: transparent"] $ 58.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]2/2/2019[/TD]
[TD="bgcolor: transparent"] $ 2.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent, align: right"]3/31/2019[/TD]
[TD="bgcolor: transparent"] $ 18.00 [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent, align: right"]2/27/2019[/TD]
[TD="bgcolor: transparent"] $ 9.00
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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