Forum Discussion

huppiac's avatar
huppiac
Copper Contributor
Mar 25, 2022
Solved

Sumif when Range is a formula

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

1 Reply

Resources