Can this be done?

[StephenSLR]

Let's say I have a chart with an 'A' column that has 'Yes' and 'No' values in the rows.

In the 'B' column I have numerical values alongside all the 'Yes' and 'No's.

I would like to know if it is possible to take all the corresponding values in the 'B' column to every 'Yes' in the A column and find the average of the 'Yes' values.

Thanks in advance

s

 

[john471]

=SUMIF(A:A,"yes",B:B)/COUNTIF(A:A,"yes")