Kalahari --

Use something like this:

=COUNTA(A1:G100)/(COUNTA(A1:G100)+COUNTBLANK(A1:G100))

HTH

"Kalahari" wrote:

I have several pages of spread sheets linked to a front page showing filled
in status, size of each sheet can shrink or grow as it is filled in, can I
display percentage filled in so I can link to it on the front page and see it
all done at a glance.