Drop down menu sum

[kodiak]

Hello,

First time posting here and I'm a new excel user. I am trying to make a biweekly time sheet for my company and I'm running into an issue. As you can see in my attached file I have my spreadsheet separated by employee, job site, and hours. I enter my jobs using a drop down menu and I want to know how many hours I'm spending at a particular job every pay period and have that totaled somewhere at the bottom or on another page. Since my job sites are chosen using a drop down menu I'm not sure how to make this happen. Any help would be much appreciated. I'm using excel 2013 on a pc. Sorry if I'm not explaining this perfect, as I said I'm new to this program.

[newdoverman]

I added a couple of formulae to the Job I.D. worksheet. Perhaps this is what you want.

[kodiak]

Wow thank you so much that's just what I wanted it to do.

[amitkr3855]

you can also try this one

In B4
=SUMPRODUCT(IFERROR(('Biweekly Time Sheet'!$E$13:$T$17=$A4)*('Biweekly Time Sheet'!$F$13:$T$17),""))
Note this is an array formula need ctrl+Shift+Enter

R's
Amit Kumar