| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting # of cells with that meet criteria in two columns
Say I have two columns of data.
DISTRICT STATUS AND DATE 10 Complete 3-2-2007 10 20 Complete 9-10-2006 20 Complete 1-1-2001 I need a function or formula that counts the number of employees who have completed training by district. For district 10 the answer would be one. For district 20 the answer would be two. My greatest challenge is how to count the column that "includes" the word Complete. Many thanks for help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count 2 columns of data that meet a certain criteria? | Excel Discussion (Misc queries) | |||
| Counting Consecutive Cells that meet Criteria | Excel Discussion (Misc queries) | |||
| Counting lines that meet TWO criteria | Excel Worksheet Functions | |||
| Counting cells that meet 2 differnet criteria | Excel Worksheet Functions | |||
| Counting Values that meet another cells criteria | Excel Worksheet Functions | |||
Threaded Mode
