I was counting from D6 where your requirements is for from D7. anyhow
i've chenged and you can try it
=COUNTA(D7:D13)/((COUNTBLANK(D7:D13)+COUNTA(D7:D13)))
Magic1;351462 Wrote:
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: 'The Code Cage Forums - View Profile:
mubashir aziz'
(http://www.thecodecage.com/forumz/member.php?userid=237)
View this thread: 'Excel, Percentof row D6:d13 with \"Y\" expressed
in E5 - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...ad.php?t=97722)
--
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