Thread: Excel, Percentof row D6:d13 with "Y" expressed in E5
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
mubashir aziz[_17_] mubashir aziz[_17_] is offline
external usenet poster
  
Posts: 1
Default Excel, Percentof row D6:d13 with "Y" expressed in E5

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

Reply With QuoteReply With Quote