Counting Formula

		Microsoft Office Forums > Microsoft Excel > Excel
Counting Formula

06-19-2011, 03:19 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Counting Formula

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Hi Karen,

To get the count of students who have completed all the tests:

Code:

=COUNTIFS(B2:B100,"<>",D2:D100,"Yes",E2:E100,"Yes",F2:F100,"Yes")

Let's say you put that formula in cell H2. Then, to get the count of students who have not completed all three tests you could use this formula:

Code:

=COUNTIF(B2:B100,"<>")-H2

Adjust the ranges to suit (I have assumed that row 1 contains column headers).

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting Colors	g48dd	Excel	2	03-13-2011 09:28 PM
Automatic counting in a looping powerpoint	RCU	PowerPoint	0	09-22-2010 12:28 PM
listing and counting words	gencoglux	Word	2	05-07-2010 05:10 PM
Counting Weeks	leroytrolley	Excel	1	08-18-2008 11:12 AM
Counting Legal Words	bulletrick	Word	0	12-30-2005 03:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:24 AM.