Sumproduct could be help you

on C2
=sumproduct(--(Sheet2!A2:A1000=a2)*(Sheet2!b2:b1000=b2),(Sheet2! c2:c1000))

Assuming:
your data is in sheet2
A2 has the name
b2 has the task
c2 has the function that will return to the sum rescpection the two
conditions


hth

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



"SFO User" escreveu:

I'm trying to sum TASK by hours over a 52 week period - ie. task A has X
number of hours associated with it over the illustrated 52 week period.

I have 3 columns of data per weekly period (NAME(s), TASK(s), HOURS). A
person can log hours on multiple tasks each week.


NAME, TASK, HOURS (this info is repeated 52 times across the columns)
Bill | task A | 25 |
Joe, task B, 22 |
Jill, task C, 33 |
Bill, task C, 20 |

Can I use some version of a SUMIF formula here?

Cheers. SFO User