In table format

code hrs code hrs code hrs total
10 8 20 8 42 10 16
12 6 11 1 40 8 15

I need to sum the hrs if the code does not equal 42. What is the best way
to accomplish task?

--
Bonita