Entries in a List Using Multiple Criteria

USING MULTIPLE CRITERIA TO COUNT ENTRIES IN A LIST 

A good way to construct a complicated formula such as this one is to proceed step by step, making sure that each part of the formula works properly before proceeding to the next step. The following example illustrates this procedure. 

use Create Names to assign the names Name, YOG, Major and Grade to the values in columns A, B, C and D, respectively. 

Well begin the development of our formula by creating a formula to count the number of students whose year of graduation is 1996. Enter the formula =YOG in any worksheet cell. Only one value can be displayed in the cell, but if you highlight YOG in the formula bar and press the F9 key (Windows) or COMMAND+= (Macintosh), the array of values will be displayed (only the first portion of the array is shown)  

Don t forget to press the Cancel button in the formula bar or use Undo before continuing, to revert back to the original formula. 

---