Using SUMIF with YEAR function in Criteria

If you want to use SUMIF, try adding first a helper column that extracts the YEAR.

e.g.

=YEAR(A2) copied down, where A2 contains date

Then SUMIF on that new column...

otherwise you can use SUMPRODUCT() if your ranges aren't too large....

If you put the years in E2:E7, e.g. just numbers 2006, 2007 etc. then you can use a formula like this in F2 copied down

=SUMPRODUCT(C$2:C$1000,(YEAR(A$2:A$1000)=E2)+0)

or SUMIFS

=SUMIFS(C:C,A:A,">="&DATE(E2,1,1),A:A,"<"&DATE(E2+1,1,1))

You can use SUMPRODUCT with the whole column too....but it isn't recommended