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!
Bookmarks