Home |
Search |
Today's Posts |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate percentage of cells that have any value
Great! That looks good. What if I make it more complicated? Let's say I have
250 rows, but only the first 100 are populated. I want the formula to look at only those rows that have been populated so far (but I want to keep my blank rows to allow for growth). So I want to say something like: What percentage of rows with a non-blank column A have a non-blank column B? Can I do that? "daddylonglegs" wrote: For range A1:A100 try =COUNT(A1:A100)/ROWS(A1:A100) "JLeck" wrote: I have a column of numbers, and I want to calculate how many rows have a non-blank in them. Regardless of the value in the cells, I want to know what percentage HAVE a (numeric) value. How do I do that? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate an average by a certain percentage? | Excel Worksheet Functions | |||
Calculate percentage based on cells with conditional formatting | New Users to Excel | |||
calculate percentage | Excel Worksheet Functions | |||
Forumla to calculate a percentage | Excel Discussion (Misc queries) | |||
calculate percentage of two cells | Excel Worksheet Functions |