Thread: Excel, Percentof row D6:d13 with "Y" expressed in E5
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default Excel, Percentof row D6:d13 with "Y" expressed in E5
hi
try this....
=COUNTIF(D6:D13,"y")/COUNTA(D6:D13)

this formula assumes that D6:D13 is all text.
Regards
FSt1

"Magic1" wrote:

How do I get a percent of D6:D13 with the letter "Y" in E5?
Reply With QuoteReply With Quote