SOLVED

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

Copper Contributor

# 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.

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

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

``=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.

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

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

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

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

``=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.