Have an

For each unique Week & Year combination the number of hours will be displayed.

What I tried so far I set up unique combination of year&week and then tried to IF(F2=Unique,SUM(A:A),"false") but this just added entire hours and not only hours that were equal to the unique value.

Some similar but different questions & answers appear on StackOverflow. This one