J
jzingman
I have in my running log:
=SUMPRODUCT((YEAR(Run!A$3:A$1008)=(ROW()+2001))*Run!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)),Run!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.
=SUMPRODUCT((YEAR(Run!A$3:A$1008)=(ROW()+2001))*Run!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)),Run!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.