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