PDA

View Full Version : Solved: Formula Improvement - Hours * Rate



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

Bob Phillips
11-03-2009, 12:10 AM
Try

=SUMPRODUCT(C9:C1000,G9:G1000)

tammyl
11-04-2009, 11:47 PM
Thankyou very much