Hi, I have an Excel formula question: I have a column of numbers that I want
to add, but I only want to add some of them. For instance:

100 Yes
200 No
50 Yes
300 Yes
250 No
500 No

I only want to add the numbers whose values have a Yes in the next column.
What is the best way to do this? Is there a way to specify this in the
formula that will add the numbers?

Thanks in advance for any information.

= Sumif( a:a,"Yes",B:B)
A B
100 Yes
200 No
50 Yes
300 Yes
250 No
500 No

"bb" wrote:

Hi, I have an Excel formula question: I have a column of numbers that I want
to add, but I only want to add some of them. For instance:

100 Yes
200 No
50 Yes
300 Yes
250 No
500 No

I only want to add the numbers whose values have a Yes in the next column.
What is the best way to do this? Is there a way to specify this in the
formula that will add the numbers?

Thanks in advance for any information.

column a column b
row 1 100 yes
row 2 200 No
row 3 50 Yes

Formula : =sumif(b1:b3,"yes",a1:a3)



"bb" wrote:

Hi, I have an Excel formula question: I have a column of numbers that I want
to add, but I only want to add some of them. For instance:

100 Yes
200 No
50 Yes
300 Yes
250 No
500 No

I only want to add the numbers whose values have a Yes in the next column.
What is the best way to do this? Is there a way to specify this in the
formula that will add the numbers?

Thanks in advance for any information.

Hi, Nikki and Anna, I just wanted to say thanks for your responses. :) I
used SUMIF and it worked great!

Thanks again! :)



"bb" wrote:

Hi, I have an Excel formula question: I have a column of numbers that I want
to add, but I only want to add some of them. For instance:

100 Yes
200 No
50 Yes
300 Yes
250 No
500 No

I only want to add the numbers whose values have a Yes in the next column.
What is the best way to do this? Is there a way to specify this in the
formula that will add the numbers?

Thanks in advance for any information.