"bassec" wrote:
Also, I need the reverse of COUNTBLANK, since that is counting the
overal percent left to complete, rather than the percent completed.

My apologies, there's a correction to the earlier formula
it should be in A21 (as you wanted %complete):
=COUNTA(A1:A20)/ROWS(A1:A20)

the problem is I'm trying to exclude certain rows (such as A3, A9 and
A13) since they are used as organizers, rather than actual data fields.
any idea on how to do that?

One way .. try instead in A21:
=COUNTA(A1:A2,A4:A8,A10:A12,A14:A20)/(ROWS(A1:A20)-3)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---