B
bb
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.
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.
I