Anybody Excel?

Harold R

501 Club
Is there anybody here working with excel spread sheets, that could que me in on a function I can't seem to find? I'm trying to find, in a column of cells, the average number of cells that are occupied........in a percentage format. For example: A column has 30 cells. 27 of those cells has something in them, 3 are empty. That column is 90% occupied.
AVG...averages the contents of the cells. COUNT....gives me the number of cells occupied (27)......but I can't figure out how to format that into 90%

I have the basic version of excel that comes with the MS Works bundle....7.0 I believe.
Thanks for any help.
 
Harold,

you can use the count function, then edit that formula by adding / (divde) by the number of total cells in the column. Then format the cell with the formula in it to give the answer in percentage.
example, 10 cells in the column. =count(A1:A10)/10 and format cell to percent
 
Harold It has been so long since I did one but when you make a data input form there is a comand to cause it to add data at the last line or rather first blank row. You could use that number -1 and your count number to make your own formula to get percentage. Ive got to do some thinking to rember how to get the number for first blank row
Bill
 
OK what Keith L says given you know the number of occupied lines (or rows) and don't add any more. I am trying to remember a wy that no matter if rows are added or removed you don't have to change your formula.
 
OK what Keith L says given you know the number of occupied lines (or rows) and don't add any more. I am trying to remember a wy that no matter if rows are added or removed you don't have to change your formula

Beacon, Keith had exactly what I was trying to do. In a group of......say apartment buildings. Each building has a fixed # of units per building. 30 units in each building. When recording rent payments on each unit per month, I wanted a cell to track building utilization....% occupancy month over month. Just to track trends.
 
Good thing! I was trying to cover the base where the number of entreys changed.

Hey I was having a fit with my old browser Netscape 7.2 I just changed over to Firefox and now have a spell checker. Boy is that somthing I need. With my natural stupidity and fat fingers spelling is a mess.
 
Back
Top