| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i count using two criteria
I have varying dates in D:D and different names in F:F such as
5/1/09 splmd2 6/1/09 armd4b 12/01/09 carbdp the names repeat as wil some of the dates. I have tried different ways to count...I want to know how may splmd2 (or whatever names are in the column) do I have that fall in a range greater than a specific date. Like =Countif D:D +=G1(a date to be determined in that cell) and if F:F=H1 (one of the names listed above) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
| count if for more than one criteria | Excel Worksheet Functions | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| count using criteria | Excel Discussion (Misc queries) | |||
| How to count nos. on 3 criteria | Excel Worksheet Functions | |||
Threaded Mode
