'Year Sheet'!C:C refers to the whole of column C on the Year Sheet worksheet.
That formula sums Column D of Year Sheet where column C of Year sheet matches G1 of the sheet that holds the formula.
Surface Pro (2017) vs Surface Pro 4
20 groundbreaking 3D animation technologies coming to Siggraph 2017
iPad Pro 12.9 vs Surface Pro 5
Synology invites you to visit them at Insomnia on 26th – 29th August. Book your tickets now and visit Synology.