SUMIF cell = "Yes"
 

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.

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

I dunno.........your formula seems to work for me in XL2k
I made my test drop down boxes with Data Validation.......maybe if you
made yours differently, therein lies the problem......


Vaya con Dios,
Chuck, CABGx3


"heater" wrote in message
...
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.

=SUMIF(K25:K85,"yes",I25:I85)
works for me
you need to check the exact spelling of Yes
there could be a space before or after.
Check the dropdown list.

Greetings from New Zealand
Bill K



"heater" wrote in message
...
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.

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

On Wed, 11 May 2005 14:39:18 -0700, heater
wrote:

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.


I can't reproduce this problem. You will need to provide more information. A
similar formula on my worksheet works as you describe.


--ron

something odd is definately happening
Try
=sumif(K25:K85,K25,I25:I85)
and toggel K25 back and forth to see what you get.


"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.

It works now. I had one cell that had something wrong with it. Thanks.

"Ron Rosenfeld" wrote:

On Wed, 11 May 2005 14:39:18 -0700, heater
wrote:

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.


I can't reproduce this problem. You will need to provide more information. A
similar formula on my worksheet works as you describe.


--ron