Forum Discussion
huppiac
Mar 25, 2022Copper Contributor
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
Use the SUMPRODUCT function instead like this...
=SUMPRODUCT((YEAR($C$3:$C$8)=E3)*$B$3:$B$8)
1 Reply
- Subodh_Tiwari_sktneerSilver Contributor
Use the SUMPRODUCT function instead like this...
=SUMPRODUCT((YEAR($C$3:$C$8)=E3)*$B$3:$B$8)