SUMIF cell = "Yes"

[Guest]

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.

 

[Ron Rosenfeld]

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

 

[CLR]

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

 

[Bill Kuunders]

=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

 

[Guest]

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]

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

 

[Guest]

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

 

[Guest]

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