Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2016, 02:39 AM
Tomas4 Tomas4 is offline COUNTIF [criteria] + give % Windows 8 COUNTIF [criteria] + give % Office 2016
Novice
COUNTIF [criteria] + give %
 
Join Date: Dec 2016
Posts: 2
Tomas4 is on a distinguished road
Default COUNTIF [criteria] + give %

Hi guys,

Was trying to crack this one up, got nothing but a head buzzing by now...


A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2
y y y y n y n n o o




What would be a formula to calculate % for:


Count ONLY if A2:L2 is 'y' AND 'n', ignoring anything else (blank or 'o')


Then give me a % for how many correct answers ('y') vs incorrect answers ('n')






So in this example it would be:


Total Count: 8 (5 x 'y' & 3 x 'n')
% Correct: 63%


Any suggestions?


Thank you!
Reply With Quote
  #2  
Old 12-20-2016, 07:01 AM
gebobs gebobs is offline COUNTIF [criteria] + give % Windows 7 64bit COUNTIF [criteria] + give % 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
  #3  
Old 12-20-2016, 10:28 AM
Tomas4 Tomas4 is offline COUNTIF [criteria] + give % Windows 8 COUNTIF [criteria] + give % Office 2016
Novice
COUNTIF [criteria] + give %
 
Join Date: Dec 2016
Posts: 2
Tomas4 is on a distinguished road
Default

Thank you!!
Reply With Quote
Reply

Tags
countif, percentage

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTIF [criteria] + give % Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached. phillipsdp Excel 1 11-09-2016 12:53 AM
COUNTIF [criteria] + give % If IF/AND Criteria is Blank, Give me "Blank" tbesh Excel 1 09-07-2015 09:43 AM
Matching Criteria against a range when criteria is not in contiguous cells?? GMorris Excel 9 08-20-2014 02:15 AM
Save As give Read Only Royce in ATL Excel 0 08-19-2012 05:34 PM
COUNTIF [criteria] + give % Countif with 2 criteria ibrahimaa Excel 3 05-23-2011 11:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft