Name Diluted Tons Heading Reliant
bbt2928_1010S_A006__ 0 bbt2928_1010S_A001__ =SUMIFS(?)
bbt2928_1010S_A001__ 0
bbt2928_1010S_A001__ 0
bbt2928_1010S_D001__ 105
bbt2928_1010S_D001__ 105
bbt2928_1010S_D001__ 105
bbt2928_1010S_D001__ 105
bbt2928_1010S_D001__ 105
bbt2928_1010S_D001__ 105
bbt2928_1010S_D001__ 105
bbt2928_1010S_D001__ 105
bbt2928_1010S_D001__ 105
bbt2928_1010L_C003__ 101


I'm hitting a brick wall with this problem and hoping you guys can help.
In plain english, what I want to do is "sum the values in Column B for only the respective value in column A that follows the value in column A that matches the value in C2"
So what I would like to see is a value of 945 in D2.
Can this be done through excel formulas or am I going to have to do some VBA for this?

Any help is appreciated!