Sum if based on horizontal and vertical criteria

[Labamba32]

Hi All - any help with this issue would be greatly appreciated.

I have a sheet where I make work assignments (including budgeted hours) to each employee by task by day. There can be multiple assignments and employees on any given day. The sheet outlines all assignments for a year and looks something like this:

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Task[/TD]
[TD]Employee[/TD]
[TD]1/1/19[/TD]
[TD]1/2/19[/TD]
[TD]1/3/19[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Sarah[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Justin[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Sarah[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]Bruce[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]Justin[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]


I then want a summary sheet where I can see the total hours assigned to an employee on any given day. It would look something like this (ideally in the format below so I can filter).

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Sarah[/TD]
[TD]Justin[/TD]
[TD]Bruce[/TD]
[/TR]
[TR]
[TD]1/1/19[/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1/2/19[/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1/3/19[/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

I realize that I can use Hlookup an manually change the array for each day since all the dates in a year is a finite group. However I was hoping for something more formula driven? Thanks in advance for you suggestions.

 

[steve the fish]

First table in Sheet1 then in Sheet2 B2:

=SUMIFS(INDEX(Sheet1!$C:$ND,,MATCH($A2,Sheet1!$C$1:$ND$1,0)),Sheet1!$B:$B,B$1)

 

[gaz_chops]

Maybe

=SUMPRODUCT(($C$1:$E$1=$A11)*($B$2:$B$6=B$10)*($C$2:$E$6))

 

[Labamba32]

First table in Sheet1 then in Sheet2 B2:

=SUMIFS(INDEX(Sheet1!$C:$ND,,MATCH($A2,Sheet1!$C$1:$ND$1,0)),Sheet1!$B:$B,B$1)

This did the trick thanks so much!!!