daverage worksheet function

[Dave]

I have the following data and want to calculate an average of the % for the
projects sold or not sold. Should I use daverage but how does the criteria
need to specified if it has to be in a range?

R1 ColA ColB ColC
R2 Project 1 10% sold
R3 Project 2 20% not sold
R4 Project 3 20% not sold
R5 Project 4 50% sold

Thanks.

 

[Jacob Skaria]

Average of percentages for 'sold'.

Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula>}"

=AVERAGE(IF(C1:C100="sold",B1:B100))

If this post helps click Yes