Assuming

Week1
Name = Column A
Task = Column B
Hours = Column C

Week 2
Name = Column D
Task = Column E
Hours = Column F

=sumproduct(--(b2:b100="a"),(c2:c100))+sumproduct(--(e2:e100="a"),(f2:f100))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"SFO User" escreveu:

This is really difficult trying to explain a problem without sending an
actual spreadsheet. Here is the data in a more concise format...

Week 1 Week 2
Name Task Hours Name Task Hours
Bill a 10 Bill b 15
Bill b 20 Joe d 15
Sue a 30 Sue a 5
Bill c 10 Bill c 5

I want to get the total number of hours spent on Task "a" across all weeks.
In this example the answer would be 45 (week 1: Bill 10 + Sue 30 + week 2:
Sue 5). This table will have 52 weeks in it.

Any help would be appreciated.

SFO User