View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bill Kuunders Bill Kuunders is offline
external usenet poster
 
Posts: 303
Default Create an Averaging Formula

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

--
Greetings from New Zealand


"KBaker" wrote in message
...
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?