Hi I would like to know how I can calculate the total amount of purchase for a specific person.

The data sheet is given in the image above. I would like to count the total purchase for the names in Column D from Column B.

I am stuck as to what excel formula I should use.

Appreciate the help!

I tried using SUMIF with VLOOKUP inside but it doesn't seem reasonable to use.

CodePudding user response：

=SUMIF($A$2:$A$11;D2;$B$2:$B$11)

SUMIF is the only function you need. You need to put an interval of all the names you are going to check and fix both the column and the row, then you put the name you need and since you have them written in another column just chose the first name and don't fix it. Lastly, you need the range of the cost again fixated.