Vlookup (SUM)

[Beachson]

I am trying to create a column D that keeps a running total of numbers I enter into column C. Here is what my set up is ...

In column A2 through A11 I have a list of item numbers and they are all identical. In Column B2 through B11 I have those same item numbers with a Location number attached to them.

As I enter a number into column C for each of these items I would like column D to show the total for the common item number in column A.

So if I enter the number 2 for all 10 item numbers I would like column D to show the number 20 because it is the column C sum of the common item number in column A.

Any help is greatly appreciated thanks.

 

[sheetspread]

=sumif($a$2:$a$11,a2,$c$2:$c$11)