Forum Discussion
Solved
Total when multiple rows have a value in column C multiplied by value in column D
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.
=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.
2 Replies
=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.
- That worked!! Thanks so much. That was a really fast answer, wow!
