ExcelBanter - daverage worksheet function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - daverage worksheet function (https://www.excelbanter.com/excel-worksheet-functions/248138-daverage-worksheet-function.html)

daverage worksheet function

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.

daverage worksheet function

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
---------------
Jacob Skaria

"Dave" wrote:

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.