Tks... the below formula gives me 68% completion when it should be 71%. Five
of the seven cells in D6:d13 have "y" entered in each, which gives me a 71%
completion.

"mubashir aziz" wrote:


Try this ......

=COUNTA(D6:D13)/((COUNTBLANK(D6:D13)+COUNTA(D6:D13)))


--
mubashir aziz

If this post helps Don't 4get to click Yes
------------------------------------------------------------------------
mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97722