How to "Add multiple cells from other collumn, if statement is true"

[ixelles]

Hi,
I cannot figure out something that i would consider really simple.
I would like the sheet to calculate, how many hours i work pr week!

Udklip.PNG

Collumn A= is the different weeknumbers
Collumn B is the hours that i work for each day.

Cell E2 should contain(??):
=SUM(B:B(IF (D1=A:A)))


I tried:
=IF(ISERROR(MATCH(D1,A:A, 0)), "No Match", (B:B))
This way I only get the first 8,5 hours, and not a total of the 16.5 hours that i work in week 18

HOW DO I DAY THE MATCHING CELLS, that are true in the other collumn

[oeldere]

I am not able to read PNG, so add a small excel file, without confidential information.

Please also add the expected result manualy in your file.

[Crooza]

Try in E2
=sumif($A$2:$a$8,D2,$b$2:$b$8)

And drag down

[ixelles]

Thank you =sumif($A$2:$A$8,D4,$B$2:$B$8) worked perfectly!

Thank you so much

[Crooza]

Great. Glad it worked