Solved: Formula Improvement - Hours * Rate

[tammyl]

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

[Bob Phillips]

Try

=SUMPRODUCT(C9:C1000,G9:G1000)

[tammyl]

Thankyou very much