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