SUMIF with conditional

[ERoemer]

I have a spreadsheet with two Rows, "Hours Worked" and "Name". In the row for each Name is the number of tasks completed.

A B C D E F
1 Hours Worked 8 7.5 5 8 6
2 Name1 6 4 4 4 3
3 Name2 7 5 6 6 8

How can I get Excel to sum the number of tasks completed for Name1 and Name 2 in Rows 2 and 3, columns B thru F, only when the "Hours Worked" number in Row 1 is = to 8? For instance in this example, Name1's total should be 10, and Name2's total should be 13...

Thanks!

[benishiryo]

hi ERoemer, try this in row 2:
=SUMIF($B$1:$F$1,8,B2:F2)

then copy down

[Tony Valko]

Like this...

=SUMIF(B$1:F$1,8,B2:F2)

copy down as needed.

[ERoemer]

That worked great! Thanks!

[Tony Valko]

You're welcome. Thanks for the feedback!