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

 

[SkipVought]

Hi Andy,

Why force the user to do one extra thing?

The enter the two values and...

VOLA! Behold...

the SUM!

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}