20 cells in the same column. How do i show, as a percentage, the cells that have values?

Say I have 2000+ blank cells in the same column. As packages are shipped I enter a date in a cell in the same column (which validates when we shipped, obviously).

In a completely separate cell, on the same sheet, I would like to have a PERCENTAGE that tells me the "percent complete" .... (i.e., if I had 10 cells and 4 had a date entered...I want a separate cell (in a completely different column) to automatically show ---> 40% ... just based off of the cells with values vs. no-values).

I understand this example could be solved with elementary mathematics, but I'm dealing with workbooks that have thousands of cells and simply don't have the time to create a "live" percentage. I just need a single cell at the top of my sheet that shows the percentage of shipped items in that workbook!

Hopefully this makes sense.


I'm sure this is extremely simple and I would really appreciate any help.

THANK YOU VERY MUCH IN ADVANCE!

Originally Posted by chemistb

how do you know where the end of your data table is? Is there another column where there will be something if an order has been made? If so, i would use that column (let's say column a) and the date column (column b) like so

=count(b:b)/counta($a2:$a5000) formatted as percentage.
Would that work for you?

yes. Thank you very much, i appreciate it!