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%.

Also, I have highlighted horizontal rows that SHOULD NOT count towards the overall value.

So, how do I do something like that, if there are say 510 total rows, with 10 highlighted rows to be excluded, and 250 rows with data in them? How do I get a total percent complete so it would read 50% complete?