=(COUNTIF(C5:C27,""&C2)-COUNTIF(C5:C27,"="&D2))/COUNT(C5:C27)
--
Best Regards,

Luke M


"Curtis" wrote:

Thanks that worked

I need to now determine the % that fails within a range says between the
value in c2 and the value in d2

Thanks

"Ron Coderre" wrote:

This formula returns the percentage of values
in C5:C27 that are greater than the value in C2.
Note: it divides by the count of numeric values in C5:C27:

=COUNTIF(C5:C27,""&C2)/COUNT(C5:C27)

Format the result as Percent

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Curtis" wrote in message
...
cell c2 = 80%

Column of data is c5:c27


I need to calculate the % of sales greater than the value in cell c2.

thanks