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
Bookmarks