Lastly the formula needs to exclde blank cell ( however the cells do contain
a formula)

"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