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

New Contributor

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 Replies
best response confirmed by Hans Vogelaar (MVP)



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


This formula calculates the total in cell D17.

hours and rates.JPG

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