2 formulas to calculate hours for every material& truck in each day

[leprince2007]

Hello Everybody,

Required:
I want 2 formulas:
1-I want a formula to calculate hours for every material in each day from "Data" sheet
2-I want a formula to calculate hours for every truck in each day from "Data" sheet

Find the attachment
I wish you help me

[kasan]

B4 formula, range marked in red should be changed for each column

=SUMIF(Data!$A$4:$A$26;Hours!A4;Data!$F$4:$F$26)

B15 formula

=SUMIFS(Data!$V$4:$V$26;Data!$B$4:$B$26;Hours!B$14;Data!$A$4:$A$26;Hours!$A15)

[leprince2007]

B4 formula, range marked in red should be changed for each column

=SUMIF(Data!$A$4:$A$26;Hours!A4;Data!$F$4:$F$26)

B15 formula

=SUMIFS(Data!$V$4:$V$26;Data!$B$4:$B$26;Hours!B$14;Data!$A$4:$A$26;Hours!$A15)

Thank you Mr. kasan for your help.But there are some marks in your answer:
1-your First formula:
You say I should change the sum range but,I want only formula only for the whole table.
2- your second formula:
I need a formula that don`t depend on any other calculations"totals"
Please help me

[leprince2007]

Up..................Up...................Up

[samba_ravi]

b4

=SUMIFS(INDEX(Data!$E$4:$T$26,,MATCH(B$3,Data!$E$2:$T$2,0)+1),Data!$A$4:$A$26,$A4)

b15

=SUMPRODUCT((Data!$A$4:$A$26=$A15)*(Data!$B$4:$B$26=B$14)*(Data!$E$3:$T$3="Hours")*(Data!$E$4:$T$26))

Try this and copy across

see the attached file

[leprince2007]

Well done thank you