I need a formula that will total all the payroll, overtime and training hours
for B and C in the below example:

A B C
1 payroll 15 8
2 overtime 5 0
3 payroll 6 22
4 training 4 4
5 training 8 11


payroll B = 21
overtime B = 5
training B = 12
payroll C = 30
overtime C = 0
training C = 15

i'm sure there is some easy formula that can do this, but i can't think of
one.
any suggestions?

thanks