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