Summing a column within dataset based on column header

[p4nny]

Hi

My dataset is similar to below

I would like to sum the values in column D, for example, based on a chosen date in cell E1. So if E1 = 22/10/2017 then E2 would = 7

Many thanks

	A	B	C	D
1		06/10/2017	29/10/2017	22/10/2017
2	BA	8	7	4
3	BA2	4	1	1
4	BA3	2	3	2

<tbody>
</tbody>

 

[Scott T]

Try

=SUM(INDEX(B2:D4,0,MATCH(E1,B1:D1,0)))