SUMIF formula

[BigPhil84]

In the 'Q1 Sum' tab im trying to write a SUMIF formula, that will capture all the normal, OT1, OT2, AL and SL from the 'Jan-March'

For example for man number A00001, he should have 24 normal hours etc

I have done a

=IF('Jan-March'!A:A='Q1 Sum'!D5,SUMIF('Jan-March'!$4:$4,"Normal",'Jan-March'!$5:$14))

However, I can't drag the formula down to work for the other man numbers, even using the $ sign, it shows 24 normal hours for man number A00002, when it should be 12

any help appreciated, attached file

[samba_ravi]

=IFERROR(SUMIF('Jan-March'!$B$4:$QI$4,E$4,(INDEX('Jan-March'!$B$4:$QI$14,MATCH($D5,'Jan-March'!$A$4:$A$14,0),))),0)
Try this in cell "E5" of Sheet Q1 Sum and copy across

[BigPhil84]

Excellent , worked perfectly

[samba_ravi]

Thanks for your reply and reputation points