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:

	2/9/2018	2/9/2018	2/16/2018
2/1/2018	5	2	1
2/2/2018	1	2	3
2/3/2018	4	5	6

<tbody>
</tbody>

Sheet 2: Need to pull from Sheet 1

	2/2/2018	2/9/2018	2/16/2018
2/1/2018	0	7	1
2/2/2018	0	3	3
2/3/2018	0	9	6

<tbody>
</tbody>

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!