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


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]06/10/2017[/TD]
[TD]29/10/2017[/TD]
[TD]22/10/2017[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]BA[/TD]
[TD]8[/TD]
[TD]7[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]BA2[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]BA3[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott T]

Try

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