View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Anna
 
Posts: n/a
Default Excel formula question

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.