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.
This site uses cookies to maintain login information on FarmallCub.Com. Click the X in the banner upper right corner to close this notice. For more information on our privacy policy, visit this link: Privacy Policy
NEW REGISTERED MEMBERS: Be sure to check your SPAM/JUNK folders for the activation email.
Anybody Excel?
-
- Team Cub Guide
- Posts: 3280
- Joined: Thu Feb 20, 2003 4:54 pm
- Zip Code: 71203
- Tractors Owned: 1948,55, and 56 Farmall Cubs.
- Circle of Safety: Y
- Location: Louisiana
-
- 10+ Years
- Posts: 229
- Joined: Wed Feb 07, 2007 8:24 pm
- Location: NJ, Califon
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
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
Keith Lukachek
55 Lo (Woods), 57 Lo(in boxes), 62 Lo(105 mower), 50 for parades, 57 FH, 58 FH, 64 Loader (Ugly Duckling), 154 (Woods), 59(Woods), 49 SAV, 58 460U Diesel
55 Lo (Woods), 57 Lo(in boxes), 62 Lo(105 mower), 50 for parades, 57 FH, 58 FH, 64 Loader (Ugly Duckling), 154 (Woods), 59(Woods), 49 SAV, 58 460U Diesel
-
- 10+ Years
- Posts: 7703
- Joined: Thu Aug 19, 2004 2:31 pm
- Zip Code: 10314
- Location: NY Staten Island & Franklin
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
Bill
-
- 10+ Years
- Posts: 7703
- Joined: Thu Aug 19, 2004 2:31 pm
- Zip Code: 10314
- Location: NY Staten Island & Franklin
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.
Bill
"Life's tough.It's even tougher if you're stupid."
- John Wayne
" We hang petty thieves and appoint the great ones to public office."
- Aesop
"Life's tough.It's even tougher if you're stupid."
- John Wayne
" We hang petty thieves and appoint the great ones to public office."
- Aesop
-
- Team Cub Guide
- Posts: 3280
- Joined: Thu Feb 20, 2003 4:54 pm
- Zip Code: 71203
- Tractors Owned: 1948,55, and 56 Farmall Cubs.
- Circle of Safety: Y
- Location: Louisiana
-
- Team Cub Guide
- Posts: 3280
- Joined: Thu Feb 20, 2003 4:54 pm
- Zip Code: 71203
- Tractors Owned: 1948,55, and 56 Farmall Cubs.
- Circle of Safety: Y
- Location: Louisiana
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.
-
- 10+ Years
- Posts: 7703
- Joined: Thu Aug 19, 2004 2:31 pm
- Zip Code: 10314
- Location: NY Staten Island & Franklin
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.
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.
Bill
"Life's tough.It's even tougher if you're stupid."
- John Wayne
" We hang petty thieves and appoint the great ones to public office."
- Aesop
"Life's tough.It's even tougher if you're stupid."
- John Wayne
" We hang petty thieves and appoint the great ones to public office."
- Aesop
Who is online
Users browsing this forum: No registered users and 0 guests