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