SUMIFS for Multi set of colums & multi criteria

Hi,
I am new to the forum, i am very much impressed by the questions and solutions posted in this forum. Happy to be a member in this forum.

I need a solution for one of my case show below. I am preparing Time sheet for monthly basis with project and its tasks, i need to track all the time spent on each project under each task in whole month ,below is the example:
Shown only for 3 dates, need to sum the time in each tasks under each project(A,B,C), need result like shown in below table.
I tryed with SUMIFS for first date with multi criteria and its working, but i need to do same for other dates and sum all the results. Please help.
Thanks in advance...Example.JPG

1) image is usefull, but attachement is better: One have a ready excel file to work on.

2) Try:

Please Login or Register  to view this content.

in B10.
Copy down and right.

While adjusting to your real data note that 1st and 3rd arguments are shifted one cell to right
B$4:BB$4 vs $C4:$BC4
Important thing: Project name cannot be number (projects A, B , 3, D etc.)

As you see not SUMIFS but SUMIF. There is just one criteria - the other (work type) can be ommited, because of data structure - you have only one type in each row.

Hello Sir,
Great.......!!!Thank you so very very much for solution and sorry for late reply.
Your solution is working for my case.....
I thought of improving my time sheet. In previous post example, I have considered only for one engineer. Now i thought of combining more than one engineer in my time sheet.
Please find the attached excel and please suggest me if my requirement is possible.

Hello Haseeb...
Thank you so very much for your solution... It worked for me....you guys are very helpfull for me...
I appreciate your skill and involvement in solving my problem...Thank you again for your support...
And Happy new year to all....