tammyl
11-02-2009, 11:27 PM
Hi,
Hoping someone may offer an improvement to this formula.
I have peoples rates in column C and the month timeline from columns D-AH. The list of personnel in column A, position in B.
Currently i have the below formula built into my totals cell, but it's needs to be manually updated everytime i insert new lines. this causes a problem with totals when formula is not modified.
=G9*$C9+G10*$C10+G11*$C11+G12*$C12+G13*$C13+G14*$C14+G15*$C15
+G16*$C16+G17*$C17+G18*$C18+G19*$C19+G20*$C20+G21*$C21+
G22*$C22+G23*$C23+G24*$C24+G25*$C25+G26*$C26+G27*$C27
Thanks
tammyl
Hoping someone may offer an improvement to this formula.
I have peoples rates in column C and the month timeline from columns D-AH. The list of personnel in column A, position in B.
Currently i have the below formula built into my totals cell, but it's needs to be manually updated everytime i insert new lines. this causes a problem with totals when formula is not modified.
=G9*$C9+G10*$C10+G11*$C11+G12*$C12+G13*$C13+G14*$C14+G15*$C15
+G16*$C16+G17*$C17+G18*$C18+G19*$C19+G20*$C20+G21*$C21+
G22*$C22+G23*$C23+G24*$C24+G25*$C25+G26*$C26+G27*$C27
Thanks
tammyl