daverage worksheet function

  • Thread starter Thread starter Dave
  • Start date Start date
D

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