Summing values based of adjacent value

[RobertSi]

Hi i have a table as follows and I would like to sum the values in column B based on the values in column A and place the answer in column D in order of column C. This is just an example of what i want the values are not 1, 2, 3 etc.

A	B	C	D
1	10	1
2	50	2
3	42	3
1	82	4
1	34
2	75
3	60
4	20
2	30

<tbody>
</tbody>

I was thinking of using "for" statements but I'm unsure of whether that will actually work is there a way to do this?
I am using excel 2010 on windows 7. I am also a beginner when it comes to VBA.

Any help would be great thanks.

 

[steve the fish]

Hi. Read up on SUMIF. In this case your range will be A2:A10, your criteria C1 and your sum range B2:B10. If you are going to drag down the formula you must absolute the range and sum range.

 

[RobertSi]

Thanks the SUMIF helped I used it as such

For a = 2 To 100
If Sheets(ComboBox1.Text).Range("M" & a) <> Blank Then
Sheets(ComboBox1.Text).Range("O" & a) = Application.WorksheetFunction.SumIf(Sheets(ComboBox1.Text).Range("F:F"), Sheets(ComboBox1.Text).Range("M" & a), Sheets(ComboBox1.Text).Range("E:E"))
End If
Next

And I got the result i wanted