Hi all,
Have a formula that is giving me a #spill error, likely because the formula is in row 87. Row 2 is months from 2023-2029, and i want to sum all the values in row 87 if the constraints hold, i.e. sum all the values for that year up to the current month. So sum jan-may if in june, jan-july if in august, etc.
Anyone know how i can rewrite this formula to be in row 87 without error? Thank you so much.
Cheers,
Ernie
=SUMPRODUCT(--(YEAR($S$2:$CX$2)=YEAR(V$2))*($S$2:$CX$2<V$2)*($S$87:$CX$87))
Have a formula that is giving me a #spill error, likely because the formula is in row 87. Row 2 is months from 2023-2029, and i want to sum all the values in row 87 if the constraints hold, i.e. sum all the values for that year up to the current month. So sum jan-may if in june, jan-july if in august, etc.
Anyone know how i can rewrite this formula to be in row 87 without error? Thank you so much.
Cheers,
Ernie
=SUMPRODUCT(--(YEAR($S$2:$CX$2)=YEAR(V$2))*($S$2:$CX$2<V$2)*($S$87:$CX$87))