SumIF/ Lookup Help

Really stuck and lucking for some help.

I have a spread sheet I use for tracking project man-hours by week by sub project task, Weeks are listed across row 1, projects are listed down column A and sub projects down column B.

What I would like to do is enter a week and a project input and for the formula to the search based on two criteria a column based on a week number and multiple rows based on a project number and then sum the results,

If I've attached this sample picture correctly you can see what I mean , the answer should be 19.

Sample.jpg

Try this
=SUMPRODUCT(($A$3:$A$9=$K$2)*OFFSET($B$3:$B$9,0,$K$3))
Not tested

Thanks guys, that worked perfectly right up until I dropped it into my working sheet and the week number changed to week 30, that's why I thought some sort of lookup. sorry my example wasn't clear
Sample 2.jpg

Or try

Formula:

Please Login or Register  to view this content.

Guys, thank you both very much, went with yours Tony in the end, felt being able to have an exact match made it a bit more bulletproof in the event someone forgot a week it can get confused.

Thanks again

Brian