View Single Post
  #1   Report Post  
blazon
 
Posts: n/a
Default Can you help me write this formula?


I'm trying to create a formula that involves counting and percents. So,
in the range A9:AE9, I want to count the number of times "y" appears
(each cell of the range has a "y", "n", or "n/a") and divide that
number by 31 (the number of columns in the range). It sounds simple,
but I can't figure it out!

Any help is appreciated.

Thanks!


--
blazon
------------------------------------------------------------------------
blazon's Profile: http://www.excelforum.com/member.php...o&userid=27409
View this thread: http://www.excelforum.com/showthread...hreadid=469224