I think I accomplished what the original poster was looking for by incorporating an IF statement into the sumproduct. In the example below, I am looking to sum individual cash flows discontinuously stacked in a column, only when they are positive.

=SUMPRODUCT(IF(CHOOSE({1,2,3,4,5,6,7,8},D25,D41,D50,D66,D96,D108,D116,D123)>0,1,0),CHOOSE({1,2,3,4,5,6,7,8},D25,D41,D50,D66,D96,D108,D116,D123))