Thread: Finding how many cells meet a criteria

Please excuse if this is a basic question but i can't do it!

I would like a cell to look at all the data in the column above it and find how many (ideally what percentage) are more than a certain value.


So in the attached spreadsheet i would like cell N39 to state what % of the cells in column N above are greater than 11

So in the attached i would like cell N40 to state what % of the cells in column N above are greater than 13

So in the attached i would like cell N41 to state what % of the cells in column N above are greater than 15


if anyone is willing to tell me how or enter the desired forula so i can see it and understand it that would be greatly appreciated.

Thanks
Stuart

Try:

=COUNTIF(N$21:N$37,">11")/COUNT(N$21:N$37)

copied across

Change 11 to 13 and to 15 for next cells below

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save