Sumif when Range is a formula

[huppiac]

Hello,

I have a table that contains values and dates in the xx.xx.xxxx format. I am now trying to sum the values for a given year using the sumif function:

but I always receive the following error:

I guess it has to do with the fact that I use the year()-function in the range but I cannot figure out to fix it. Any help would be greatly apprectiated because this is really driving me crazy (and I hope that it is not just due to me overlooking the obvious... :))

Thanks

Fabian

[#2 · Accepted solution]

@huppiac 

Use the SUMPRODUCT function instead like this...

=SUMPRODUCT((YEAR($C$3:$C$8)=E3)*$B$3:$B$8)