If formula with a index and match not working

[cgroup18]

I have a few date ranges, Column A2 and down and Row 2B to the right.

I have multiple dates of the rows and would like a SUMIF formula to pick up the correct amount.

Example:
Sheet 1:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]2/9/2018[/TD]
[TD]2/9/2018[/TD]
[TD]2/16/2018[/TD]
[/TR]
[TR]
[TD]2/1/2018[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2/2/2018[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2/3/2018[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
</tbody>[/TABLE]

Sheet 2: Need to pull from Sheet 1
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]2/2/2018[/TD]
[TD]2/9/2018[/TD]
[TD]2/16/2018[/TD]
[/TR]
[TR]
[TD]2/1/2018[/TD]
[TD]0[/TD]
[TD]7[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2/2/2018[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2/3/2018[/TD]
[TD]0[/TD]
[TD]9[/TD]
[TD]6[/TD]
[/TR]
</tbody>[/TABLE]


Current Formula I have is:

=SUMIF(Sheet1!$A$6:$A$65,'Sheet2'!$A14,INDEX(Sheet1!$B$6:$CC$65,1,MATCH('Sheet2'!P$8,Sheet1!$B$5:$CA$5,0)))


I get value '0' and not 7 for intersection 2/1/2018 and 2/9/2018.

Please help!

 

[Eric W]

Welcome to the Board.

Based on your sample sheets, try this in B2:

=SUMPRODUCT(Sheet1!$B$2:$D$4*(Sheet1!$A$2:$A$4=$A2)*(Sheet1!$B$1:$D$1=B$1))

Drag down and to the right as needed. Based on your formula, you'll need to adapt the ranges. Let us know if you need help with that.

 

[cgroup18]

Yes thanks for your help!