Thread: [Solved] COUNTIF [criteria] + give %
View Single Post
 
Old 12-20-2016, 07:01 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Code:
=countif(A2:L2,"y")/(countif(A2:L2,"n")+(countif(A2:L2,"y"))
Reply With Quote