What is the formula for percentage OVER average amount in Excel?
I have a cell that contains the average number and I want another cell that shows the percent of items over the average number.
I have a cell that contains the average number and I want another cell that shows the percent of items over the average number.
Greg G
Favorite Answer
Let's say your values are in column A, and the average is in B1.
=COUNTIF(A:A, ">" & B1) / COUNT(A:A)
First, this will count the values greater than the average, then divide by the total count of cells that contain numbers in the same range. Format the cell with this formula as Percentage.