sum a date range

[Gealer]

Hi, I have 2 tabs the 1st has a list with 200+ task ID's which is listed in Column E and then another tab with all of the data.
The 2nd tab with the data on has the date running down column A and then the Task Id in Row 1.
I have been using the following formula to retrieve the data from an date but I would now like the ability to sum everything between a second date.
This formula is next to every task id on the 1st tab - =VLOOKUP('Data Analysis KVI'!$D$1,'Total Volumes'!A:ALL,HLOOKUP($E2,'Total Volumes'!B:ALL,2,FALSE),FALSE) which works just fine.

Task ID	Actual Volumes
59134	0
59135	0
59136	0
59137	0
59138	0
59139	0
59140	0

<colgroup><col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;"> <col width="64" style="width: 48pt;"> <tbody> </tbody>

2nd tab looks like this

Task ID	59134	59135	59136	59137
Column#	2	3	4	5
Date
24/12/2018
25/12/2018
26/12/2018
27/12/2018
28/12/2018
31/12/2018
01/01/2019
02/01/2019
03/01/2019

<colgroup><col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="64" style="width: 48pt;" span="4"> <tbody> </tbody>

With this being my input

Start Date	01/01/19
End Date

<colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;"> <col width="168" style="width: 126pt; mso-width-source: userset; mso-width-alt: 6144;"> <tbody> </tbody>

So if there is nothing in the end date it will just return the single cell value and then with an end date input it will add up everything inbetween and including the dates.

Thanks in advance

 

[oldbrewer]

										start date	03/11/2018
										end date	05/11/2018
		task	volume							59134	59135	59136	59137	59138	59139	59140
		59134	336							41	44	21	39	24	37	24
		59135	298
		59136	318
		59137	332
		59138	308
		59139	340
		59140	326
		59134	59135	59136	59137	59138	59139	59140
	01/11/2018	10	6	17	1	1	2	9				is this what you want ?
	02/11/2018	5	11	18	2	9	4	13
	03/11/2018	20	8	3	15	13	19	4
	04/11/2018	19	20	2	8	3	9	1
	05/11/2018	2	16	16	16	8	9	19
	06/11/2018	9	1	8	15	2	18	17
	07/11/2018	4	11	2	18	20	13	9
	08/11/2018	18	4	19	5	10	12	13
	09/11/2018	19	17	3	9	17	13	12
	10/11/2018	5	20	5	16	2	9	7
	11/11/2018	3	5	10	17	9	13	7
	12/11/2018	9	2	17	10	14	8	19
	13/11/2018	17	11	2	20	3	11	11
	14/11/2018	9	8	18	13	16	9	20
	15/11/2018	10	8	14	4	20	20	15
	16/11/2018	18	9	5	15	1	17	1
	17/11/2018	13	19	19	15	3	11	6
	18/11/2018	11	3	5	4	20	8	1
	19/11/2018	20	4	11	19	5	16	18
	20/11/2018	8	17	4	5	2	4	20
	21/11/2018	4	11	4	19	10	8	1
	22/11/2018	3	7	1	11	14	17	6
	23/11/2018	15	9	17	3	18	14	2
	24/11/2018	16	9	4	17	14	1	2
	25/11/2018	9	8	19	18	16	10	12
	26/11/2018	10	6	19	10	16	13	16
	27/11/2018	9	17	17	2	1	15	17
	28/11/2018	12	2	2	1	17	3	13
	29/11/2018	20	14	19	20	4	16	15
	30/11/2018	9	15	18	4	20	18	20

<colgroup><col><col><col span="9"><col><col span="6"></colgroup><tbody>
</tbody>

 

[Gealer]

yes that is what I need. From the data set at the bottom it will return what ever in the date(s) at the top. Most of the time it will just be the 1 day but I will need to complete analysis weekly or monthly hence the other criteria.

So Monthly the figures would be

Start Date	01/11/2018
End Date	30/11/2018
	task	volume
	59134	336
	59135	298
	59136	318
	59137	332
	59138	308
	59139	340
	59140	326

<colgroup><col width="113" style="width: 85pt; mso-width-source: userset; mso-width-alt: 3616;"> <col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2656;"> <col width="165" style="width: 124pt; mso-width-source: userset; mso-width-alt: 5280;"> <tbody> </tbody>

or

Start Date	03/11/2018
End Date	05/11/2018
	task	volume
	59134	41
	59135	44
	59136	21
	59137	39
	59138	24
	59139	37
	59140	24

<colgroup><col width="113" style="width: 85pt; mso-width-source: userset; mso-width-alt: 3616;"> <col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2656;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 2784;"> <tbody> </tbody>

If there is a vba code that could be used I will be happy with that as well