What Excel function do I use for this?

Question

Basically I just want the correct formula for G3 in this sheet based off the values input into the D column:

So in the example the addition would be (2 + 8 + 1 + 8 + 2) = 21. I've tried looking this up but I'm unsure to the wording so it's been hard to find any solutions. Thank you!

Answer 1

Nevermind I figured it out! I just used VLOOKUP in a backend sheet and then used that to get the total for the numbers I'm wanting. I appreciate the help!

Answer 2

To add the values in those shaded cells in column D , type the following into G3:

=SUM(D2:D6)