Create an Averaging Formula

[KBaker]

How do you create a formula that identifies the numbers in a range of cells
that are equal to or greater than a number for example. What percentage of a
set of cells contain a value greater than 80?

 

[Bill Kuunders]

something like this
=COUNTIF(C1:C8,">80")/COUNT(C1:C8)*100