Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
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.
1 Answer
- Greg GLv 78 years agoFavorite 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.
