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.