How to Match a string in column A and sum the values in column B that matched

[plcoomer]

Hello,
thanks in advance for your help.

I'm trying to search for a String (lets say "2258" which lives in userform1.Textbox1.text ) in worksheet in range "A2:A800" and then sum all the values in range "B2:B800" which matched.

I can find one easy enough but when there are multiplu 2258's I don't know how to step through the data and collect them all.

 

[DanteAmor]

Put the following in a commandbutton:

Private Sub CommandButton1_Click()
  Dim xd
  xd = WorksheetFunction.SumIf(Range("A2:A800"), TextBox1.Value, Range("B2:B800"))
  MsgBox xd
End Sub

--------------
Let me know the result and I'll get back to you as soon as I can.
Cordially
Dante Amor
--------------