ExcelBanter - Create an Averaging Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Create an Averaging Formula (https://www.excelbanter.com/excel-discussion-misc-queries/243785-create-averaging-formula.html)

KBaker

Create an Averaging Formula

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

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?

All times are GMT +1. The time now is 10:35 AM.