Something like this in say, A21:
=COUNTBLANK(A1:A20)/ROWS(A1:A20)
with A21 formatted as percentage
should suffice
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bassec" wrote in
message ...

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?


--
bassec
------------------------------------------------------------------------
bassec's Profile:
http://www.excelforum.com/member.php...o&userid=32888
View this thread: http://www.excelforum.com/showthread...hreadid=526927