| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting with Date Range as Criteria
A B
1 Date Successful 2 10/1/09 Y 3 10/1/09 N 4 10/5/09 Y 5 11/3/09 Y I want to put a formula into a worksheet called "Analysis" to count the number of Y (successful) records for a given date range in a worksheet called "Master". So, I want the Anaylsis worksheet to show me "2" when I ask for the number of Y's in column B for the date range 10/1/09 to 10/30/09 in column A. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting number of rows between date range and meeting 2 string criteria | Excel Worksheet Functions | |||
| counting a number of cells with 2 range criteria | Excel Discussion (Misc queries) | |||
| Conditional Formula, counting one criteria in a range based on ano | Excel Worksheet Functions | |||
| Counting cells in a range per multiple criteria . . . | Excel Worksheet Functions | |||
| Counting from one range to another range, multiple criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
