Search table, data retrieval

[Andyd74]

I am trying to retrieve data from a table on the push of a search button
where the selection is based on at least 2 criteria being selected and
then outputting this data in another cell. I.e. I want to retrieve the
total value from one column in the table where the "name" is "Andy" and
the "age" is "25".

I have this working using a normal SUMPRODUCT statement but i want this
to happen on the click of a button. So Can someone suggest some VBA code
that would allow me to do this.

Thanks

 

[Guest]

Private Sub CommandButton1_Click()
Range("B9").Value = Evaluate("your sumproduct formula")
End Sub