Total when multiple rows have a value in column C multiplied by value in column D

[Lorna_FCF]

I have multiple rows. I have a value in column C that is multiplied by a value in column D. At the bottom of the rows, I need a total. The values in both C and D will vary, but in the end, I need a total of all. Column C is hours worked, column D is rate per hour. The rate per hour will vary depending on the work done.

[#2 · Accepted solution]

@Lorna_FCF 

=VLOOKUP(C2,$G$3:$H$6,2,TRUE)

You can try this formula along with a reference table in range $G$3:$H$6 in this example.

=SUMPRODUCT($C$2:$C$15,$D$2:$D$15)

This formula calculates the total in cell D17.

 

[#3]

That worked!! Thanks so much. That was a really fast answer, wow!