Sumif to determine total hours spent on a project

[kschmit1]

Hello,

In the attachment on the 2016 tab I have a list of 'Actual Times' spent on projects. What I am seeking to do is sum up the total actual hours spent per project on the Completed Projects tab.

For Example I know 16 hours was spent between November and December on Access Recert Admin, but I would like this automatically generate into the Completed Projects tab for this (Disregard the end date I included on that tab for the project)

I was experimenting with a formula similar to the below but have been unsuccessful:

=SUMIFS('2016'!$B:$B,'Completed Projects'!B14,'2016'!$N:$N)

I'm pretty sure I'm missing a criteria somewhere, any help would be appreciated. Thanks!

[JohnTopley]

Try

=SUMIF('2016'!$B:$B,'Completed Projects'!$B3,'2016'!$N:$N)

[kschmit1]

Thank you noticing my own mistake there!!! I guess I had it after all, just wasn't looking at the right number!