I have in my running log:

=SUMPRODUCT((YEAR(Run!A$3:A$1008)=(ROW()+2001))*Ru n!C$3:C$1008)

which works just fine.
This seems to be a waste of sumproduct, so I tried replacing the * with a ,

=SUMPRODUCT((YEAR(Run!A$3:A$1008)=(ROW()+2001)),Ru n!C$3:C$1008)

This yields 0. When I debug, I see that there are a series of nonzero
values for each entry, but the sumproduct is still 0.


Using CTRL+SHIFT+ENTER doesn't help.