The problem is it totals everything in column "I", no matter if cell
K25:k85="Yes", "No" or is blank. If column K25="NO", I do not want it to
total the sum in cell I25.

"Ron Rosenfeld" wrote:

On Wed, 11 May 2005 13:49:22 -0700, heater
wrote:

I have a column with a drop down list with "Yes" and "No". Another column
has values. I need a formula that sums the values only if "Yes" is selected.
If "No" is selected or the cell is blank, I don't want the value in column
"I" to be added. I have tried the following: =sumif(K25:K85, "Yes",I25:I85).
This sums all the values entered from I25:I85.

And your problem is ???


--ron