Anybody Excel?

[Harold R]

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.

[Keith L]

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

[beaconlight]

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

[beaconlight]

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.

[Harold R]

YES YES YES! That's exactly what I needed. Thanks so much Keith.

[Harold R]

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.

[beaconlight]

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.