SUMIFS statement for a range?

[Waterville]

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!

[Dunc3142]

I think I have what you want. Not SUMIFS just SUMIF.

[Tank997]

Try this.

Please Login or Register  to view this content.

[Waterville]

Thanks, but this isn't exactly where I'm hitting my wall. I don't know how to tell excel to search for the value in column A that is found in that range after the value in C1 and sum that value's respecive numbers in column B.
So I want everything in column B that has a bbt2928_1010S_D001__(and only this value) next to it to be summed.
Sorry if I'm being unclear, its kind of tough to explain i suppose, hence the reason I asked if I may have to use code for this.

[Tank997]

The value in C2 only matches A3 and A4 and the amount in B3 and B4 are both 0 so the result is 0. Try changing C2 to "bbt2928_1010S_D001__" and you will get a number. Maybe I'm misunderstanding the question again??

Edit: it just occurred to me that you may be trying to do a countif or countifs is that what you need?

[Waterville]

Yeah, sorry for not being clear. I'm wanting to say "Find the value in C2 in column A. Find the next value in column A that follows the value in C2."
So I want B5 through B13 summed. These are the values that correspond to bbt2928_1010S_D001__, which is the next value in the column after the value found in C2.