hello
I have 2 columns N&O N:the Yield and O: How much I have in that security.
everytime I add a new security I add a new row and I fill it.
However, I have a cell at the end of column O which I have to add manually
the following part everytime I add a security:
=((N4*O4)+(N5*O5)+(N6*O6)+(N7*O7)+(N8*O8)+(N9*O9)+ (N10*O10)+(N11*O11)+(N12*O12)+(N13*O13)+(N14*O14)+ (N15*O15)+(N16*O16)+(N17*O17)+(N18*O18)+(N19*O19)+ (N20*O20)+(N21*O21)+(N22*O22)+(N23*O23)+(N24*O24)+ (N25*O25)+(N26*O26)+(N27*O27)+(N28*O28)+(N29*O29)+ (N30*O30)+(N31*O31)+(N32*O32)+(N33*O33)+(N34*O34)+ (N35*O35)+(N36*O36)+(N37*O37)+(N38*O38)+(N39*O39)+ (N40*O40)+(N41*O41)+(N42*O42)+(N43*O43)+(N44*O44)+ (N45*O45)+(N46*O46)+(N47*O47)+(N48*O48)+(N49*O49)+ (N50*O50)+(N51*O51)+(N52*O52)+(N53*O53)+(N54*O54)+ (N55*O55)+(N55*O55))/O57

Multiply every security nominal amt into the Yield and then divide them over
the total.
IS THERE ANY FORMULA THAT I PUT TO DO the CALCULATION AUTOMATICALLY??