Stan Altshuller wrote...
I have return streams going down colums B through I
Dates are down column A
I want colum J to give me the weighted return for the streams of
returns.
But it must re-allocate to funds that have performance and not count
funds
that do not. So the Dec-01 portfolio return should be 50% fund 2, and
50%
Fund 3, and 0% fund 1
the allocations are in row 45 and should be flexible to be adjusted as
needed.

Fund1 Fund2 Fund 3 Portfolio
Dec-01 -1.88% 0.36% -0.51%
....
Nov-04 1.65% 2.15% 0.85% 1.55%
Dec-04 1.79% 1.40% 0.91% 1.37%
....
Allocations 33.3% 33.3% 33.3% 100.00%

Avoid using proportional typefaces in newsreaders.

Given the allocations of 33.3% for all funds, so 50/50 for Dec-01, how
do you get a portfolio return of -0.51% from fund returns of -1.88% and
0.36%? Simple average could be -0.76%. To get that, I could have used
the formula

=SUMPRODUCT(B2:D2,B$45:D$45)/SUMIF(B2:D2,"<",B$45:D$45)