Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting multiple criteria involving dates
Hey everyone,
I need to count the number of instances a row meets a few requirements. For example, the row contains the following data: A B C D 1|| Active Mechanic 2/28/2005 9/9/2005 2|| Terminated Mechanic 9/1/2004 8/19/2005 3|| Leave Janitor 7/27/1991 5/16/2005 I want to count all those who are A) Terminated, B) a Mechanic, and D)between 1/1/2005 and 12/31/2005. The results from the above data should be "1". Any advice? I'd like to use this array [ctrl-shift-enter] but can't figure out how to get date ranges in the =SUM((A1:D3="Terminated")*(B1:B3="Mechanic")) TIA! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting multiple criteria involving dates
{=SUM((DD!A3:DD!A945="Terminated")*(DD!D3:DD!D945= "Mechanic")*(DD!J3:DD!J945DATE(C1,1,1))*(DD!J3:DD !J945<DATE(C1,12,31)))}
Got it, thanks anyway:) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting multiple criteria involving dates
Sorry, that last reply had the year "2005" at c1, and started at A3,
unlike the above example. Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Countif on multiple dates | Excel Worksheet Functions | |||
counting with a criteria in multiple transactions | Excel Worksheet Functions | |||
Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
counting entries between two dates? | Excel Worksheet Functions |