Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-19-2011, 10:33 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Counting Formula Windows 7 32bit Counting Formula Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi Karen,

That would imply that all of the students have completed all of the tests. If that's not the case then please can you attach the workbook for us to see?
Reply With Quote
  #2  
Old 06-19-2011, 04:56 PM
Karen615 Karen615 is offline Counting Formula Windows 7 64bit Counting Formula Office 2010 64bit
Competent Performer
Counting Formula
 
Join Date: Jun 2011
Location: Chicago
Posts: 145
Karen615 is on a distinguished road
Default

Thank you much Colin.
Attached is the spreadsheet.

If if's not too much trouble, would you please explain the formula below in layman's terms?
=COUNTIFS(A3:A295,"<>",C3:C295,"Yes",D3295,"Yes",E 3:E295,"Yes")
Attached Files
File Type: xls Tests.xls (197.0 KB, 15 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting Formula 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
Counting Formula listing and counting words gencoglux Word 2 05-07-2010 05:10 PM
Counting Formula 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 08:40 PM.


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