Adding Columns of Data

R

robofanuc

I have a question about adding data in selected cells.

Let's say that column "G" contains dollar values, and that column "J"
contains the text either "yes" or "no". I want to sum all the dollar
values where the adjacent cell is "yes" only.

How would I accomplish that?

Thanks,
Brian
 
Top