Help with formula

[Judy L]

I have ten columns, one for each day of the week and one to input a "Code #"
for each day. I need the weekly totals of the hours by code#.

EG: Monday Code# Tues Code# Wed Code#
5 102 5 100 8 120
2 105 6 25 4 102

Weekly Total Code# 102-9 Code# 105-2

I have tried SUMIF but I keep getting an error, it works for the first two
columns, but when I try to add the others using array I get an error.
Can anyone help?

Thank you

 

[Teethless mama]

=SUMPRODUCT((B2:J3=102)*A2:I3)

 

[Judy L]

Thank you, Thank you, it worked perfect!

=SUMPRODUCT((B2:J3=102)*A2:I3)

 

[Teethless mama]

You're welcome!

Thank you, Thank you, it worked perfect!