Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Percent Complete?
I am inputting large numbers of data in vertical columns. At the bottom of the column, I would like to put a function in that shows the percent complete of that column.
Basically, if one of the fields have data in it, it counts towards the overall percentage complete. So if 250 of 500 data fields have data, the percent on the bottom should read 50%. So, how do I do something like that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percent Complete?
Assuming you are using column A. In Cell A502 your formula would be =Countif(A1:a500,"<")/500 format this cell as a percentage. -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=527001 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
two columns percent in third | New Users to Excel | |||
Percent Change | Excel Discussion (Misc queries) | |||
Show data used and percent label | Charts and Charting in Excel | |||
Formatting a number to look like a Percent without a percent sign | Excel Discussion (Misc queries) | |||
percent formulas | Excel Worksheet Functions |