Sum multiple results from a vlookup based on dropdown value

Hello,

I am wondering if the following is possible:

In a workbook, I have a cell called Result which sums a few numbers (amounts in $ in this case). Above it is a dropdown containing percentages (25%, 50%, 75%, 100%) which should influence the sum of the Result cell.

Is it possible, for example, to set the dropdown value to 25% and automatically perform a lookup for all rows containing that 25% value, fetch the values contained in the Amount cells associated to those rows and add them to the original amount displayed in the Result cell?

Since I am having a hard time putting my question into words, I have attached a sample workbook explaining what I am trying to do. The cells of interest are colored in orange/yellow. At the bottom of the "budget 2009-2010" worksheet is a cell called Result with a dropdown right above it. When changing the dropdown value, I would like to get all the values in the Amount column of the Opportunities worksheet where the Probability (%) value is the same as that of the dropdown in the "budget 2009-2010" worksheet and add them to the Result cell of the "budget 2009-2010" worksheet.

Any help will be appreciated!

Try this formula in T57

=T54+SUMIF(Opportunities!K:K,T56*100,Opportunities!H:H)

That worked wonders, I was not aware of the SUMIF function. Thank you very much for the quick reply!

EDIT: Actually, I do have one last question. I would like to change the formula to look for not only the value in T56, but for that value and anything below it. In other words, if I chose 50%, I would like to sum the values associated to 50% and anything below that. I tried the following to no avail:

Please Login or Register  to view this content.

The syntax would be like this

=T54+SUMIF(Opportunities!K:K,"<="&T56*100,Opportunities!H:H)

Unfortunately, the results are the same with the syntax you provided. The entire SUMIF part seems to be ignored and only the amount in T54 is displayed. I have checked and all the concerned cells are in the appropriate data type as well.

EDIT: Problem has been fixed. Removing the *100 from the formula did it. I must have made a mistake in the cell format.

Thank you very much for your help!