software

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:

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

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,quot;Yesquot;,B:B)
A B
100Yes
gt; 200No
gt; 50Yes
gt; 300Yes
gt; 250No
gt; 500No

quot;bbquot; wrote:

gt; Hi, I have an Excel formula question: I have a column of numbers that I want
gt; to add, but I only want to add some of them. For instance:
gt;
gt; 100Yes
gt; 200No
gt; 50Yes
gt; 300Yes
gt; 250No
gt; 500No
gt;
gt; I only want to add the numbers whose values have a Yes in the next column.
gt; What is the best way to do this? Is there a way to specify this in the
gt; formula that will add the numbers?
gt;
gt; Thanks in advance for any information.

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

Formula : =sumif(b1:b3,quot;yesquot;,a1:a3)
quot;bbquot; wrote:

gt; Hi, I have an Excel formula question: I have a column of numbers that I want
gt; to add, but I only want to add some of them. For instance:
gt;
gt; 100Yes
gt; 200No
gt; 50Yes
gt; 300Yes
gt; 250No
gt; 500No
gt;
gt; I only want to add the numbers whose values have a Yes in the next column.
gt; What is the best way to do this? Is there a way to specify this in the
gt; formula that will add the numbers?
gt;
gt; 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!
quot;bbquot; wrote:

gt; Hi, I have an Excel formula question: I have a column of numbers that I want
gt; to add, but I only want to add some of them. For instance:
gt;
gt; 100Yes
gt; 200No
gt; 50Yes
gt; 300Yes
gt; 250No
gt; 500No
gt;
gt; I only want to add the numbers whose values have a Yes in the next column.
gt; What is the best way to do this? Is there a way to specify this in the
gt; formula that will add the numbers?
gt;
gt; Thanks in advance for any information.