COUNTIF [criteria] + give %

		Microsoft Office Forums > Microsoft Excel > Excel
COUNTIF [criteria] + give %

12-20-2016, 07:01 AM

gebobs

Windows 7 64bit COUNTIF [criteria] + give %

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

Code:

=countif(A2:L2,"y")/(countif(A2:L2,"n")+(countif(A2:L2,"y"))

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
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 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 12:38 AM.