How to Add timesheet daily hours activity wise

In monthly timesheet i have fill information like how many hours a day I worked for each project and under which function / department I provided support e.g Procurement, HR, Finance etc

For example on day 1 I worked 2 hours for Project 1 in Procurement Department, another 2 hours for project 2 in Finance department and 4 hour for Project 3 again in Procurement department.

Now I want that for Project 1 total hours should be calculated department wise like how total hours I supported project 1 in Finance activity, how many in procurement etc.

I have attached the excel sheet which have all the data and I need the formula for calculation of hours activity wise in cell BM, BN, BO, BP, BQ, BR.

Will be grateful for support

Originally Posted by zurkal

99 views and no solution so far!!!! hello mods any body can help with this

In BG6 cell

Formula:

Please Login or Register  to view this content.

Drag it down and right