SOLVED

Sumif when Range is a formula

Visitor

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:

huppiac_1-1648172440065.png

 

 

but I always receive the following error:

huppiac_2-1648172686038.png

 

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

1 Reply
best response confirmed by huppiac (Visitor)
Solution

@huppiac 

 

Use the SUMPRODUCT function instead like this...

 

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