Thread: Excel - Percentage
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Sheeloo Sheeloo is offline
external usenet poster
  
Posts: 793
Default Excel - Percentage
=COUNTIF(D6:D13,"Y")
will give you the count of cells having "Y" as their value...


"Magic1" wrote:

How do I get a percentage of D6:d13 with the letter "Y" in cell E5
Reply With QuoteReply With Quote