Sum of hours per tester

**cescal** · 02-16-2011, 12:53 PM

I would like to know how to add the total number of hours that each tester has, taking in consideration the following: a) The duration time for each course is in a cell by itself. b) Not all testers are taking all courses. c) Each tester will schedule an specific month as to when to take the test using the drop down table. Thanks in advance

**NBVC** · 02-16-2011, 01:04 PM

If you enter Tester 1 in B15 and Tester 2 in C15, then in B16 enter formula:

=SUMPRODUCT(($A$4:$A$5=B$15)*($B$4:$F$5=$A16)*($B$2:$F$2))

copied over to next column(s) and down

**cescal** · 03-03-2011, 03:51 PM

thanks for the help in advanced. I used the formula that you provided and it worked great. I used it to total the number of hours assigned to each tester. I took the same formula and tried to apply it next to it to now total the number of training hours taken but it only gives me a total of zero. thanks again

**NBVC** · 03-03-2011, 04:06 PM

You have to play with the ranges to ensure you have the offset in ranges and that the ranges are of equal widths...

Try:

=SUMPRODUCT(($A$4:$A$6=B$22)*($C$4:$K$6=$A23)*($B$2:$J$2))