Sum value from differents fields of a list

Hi! I am creating an excel chart as a calendar to impute the time I spend on each project in each day (in this example the projects are AAAA, BBBB, CCCC, although there are really many more cases due to sub-tasks, etc.).

For each day I can choose in each row by means of a drop-down menu the project or task that I have done and then I put the time dedicated.

img1.png

The list of projects and tasks that the drop-down list contains is on a different sheet.

What I would like to do next is to have the total sum of the time dedicated to each project in the month, in the separated sheet where I have the list of projects.

img2.png

The way I've tried it is through the function: SUM.YES but I'm left with a very long function so I'd like to ask if there's an easier way to do it.