Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm trying to count the number of rows that matches multiple criteria in
multiple ranges. As an example, I want to count the number of rows where both Column A and Column B have a date between 01-01-05 and 12-31-05. Whe Column A Column B 01-02-05 12-20-05 01-06-05 02-20-06 05-06-09 03-07-05 01-02-06 01-09-06 So, in this instance, I want it to count only row 1 because both columns match the criteria. I've tried a couple of different Countif statements, but I can never get it to count using the multiple criteria and ranges. Please assist. Things I've tried: =Countif(and(A:A,B:B), ""&C1))+countif(and(A:A,B:B), "<"&D1) - - where C1 is equal to 01-01-05 and D1 is 12-31-05 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
counting a number of cells with 2 range criteria | Excel Discussion (Misc queries) | |||
Counting cells in a range per multiple criteria . . . | Excel Worksheet Functions | |||
Counting from one range to another range, multiple criteria | Excel Discussion (Misc queries) | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |