formula to derive time taken for a task in a day

Hi Team,

In Sheet Result tab, I need to find out which task took how much time on respective WD (Work Day).

I tried using SUMIFS but couldn’t able to derive the outcome. Can anyone please let me know, the formula to use to resolve this query?

In DATA sheet required information is available.

PFA with this thread

In C2, try

=SUMPRODUCT((Data!$A$2:$A$57=$A2)*(Data!$B$2:$B$57=$B2)*(Data!$F$2:$F$57=C$1)*(Data!$C$2:$C$57))

Drag down and to the right as far as needed.

Sumifs should work

=SUMIFS(Data!$C:$C,Data!$A:$A,$A2,Data!$B:$B,$B2,Data!$F:$F,C$1)