| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add number of days within a department for a given time period
This is the formula I'm using to calc the number of days within date range
(aug - sep). this works great. =SUMIF('Filled Reqs'!$R$2:$R$386,"="&DATE(2007,8,1),'Filled Reqs'!$T$2:$T$386)-SUMIF('Filled Reqs'!$R$2:$R$386,"="&DATE(2007,9,1),'Filled Reqs'!$T$2:$T$386) I need to break this down further by department. when I add the SUMIF command before the last node('Filled Reqs'!$T$2:$T$386) to be included as an additional check (for a specific dept within a give month add the total days), It doesn't work. I don't get the right results, syntax errors, unbalanced (), I'm getting them all. Please advise Thanks, Ralph |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add number of days within a department for a given time period
=SUMPRODUCT(--('Filled Reqs'!$R$2:$R$386=DATE(2007,8,1)),--('Filled
Reqs'!$R$2:$R$386<=DATE(2007,8,31)),--('Filled Reqs'!$O$2:$O$386="analyst"),'Filled Reqs'!$T$2:$T$386) -- Biff Microsoft Excel MVP "Ralph D''Andrea" wrote in message ... This is the formula I'm using to calc the number of days within date range (aug - sep). this works great. =SUMIF('Filled Reqs'!$R$2:$R$386,"="&DATE(2007,8,1),'Filled Reqs'!$T$2:$T$386)-SUMIF('Filled Reqs'!$R$2:$R$386,"="&DATE(2007,9,1),'Filled Reqs'!$T$2:$T$386) I need to break this down further by department. when I add the SUMIF command before the last node('Filled Reqs'!$T$2:$T$386) to be included as an additional check (for a specific dept within a give month add the total days), It doesn't work. I don't get the right results, syntax errors, unbalanced (), I'm getting them all. Please advise Thanks, Ralph |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add number of days within a department for a given time period
Biff,
Thanks for the timely response. Works great Ralph "T. Valko" wrote: =SUMPRODUCT(--('Filled Reqs'!$R$2:$R$386=DATE(2007,8,1)),--('Filled Reqs'!$R$2:$R$386<=DATE(2007,8,31)),--('Filled Reqs'!$O$2:$O$386="analyst"),'Filled Reqs'!$T$2:$T$386) -- Biff Microsoft Excel MVP "Ralph D''Andrea" wrote in message ... This is the formula I'm using to calc the number of days within date range (aug - sep). this works great. =SUMIF('Filled Reqs'!$R$2:$R$386,"="&DATE(2007,8,1),'Filled Reqs'!$T$2:$T$386)-SUMIF('Filled Reqs'!$R$2:$R$386,"="&DATE(2007,9,1),'Filled Reqs'!$T$2:$T$386) I need to break this down further by department. when I add the SUMIF command before the last node('Filled Reqs'!$T$2:$T$386) to be included as an additional check (for a specific dept within a give month add the total days), It doesn't work. I don't get the right results, syntax errors, unbalanced (), I'm getting them all. Please advise Thanks, Ralph |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add number of days within a department for a given time period
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Ralph D''Andrea" wrote in message ... Biff, Thanks for the timely response. Works great Ralph "T. Valko" wrote: =SUMPRODUCT(--('Filled Reqs'!$R$2:$R$386=DATE(2007,8,1)),--('Filled Reqs'!$R$2:$R$386<=DATE(2007,8,31)),--('Filled Reqs'!$O$2:$O$386="analyst"),'Filled Reqs'!$T$2:$T$386) -- Biff Microsoft Excel MVP "Ralph D''Andrea" wrote in message ... This is the formula I'm using to calc the number of days within date range (aug - sep). this works great. =SUMIF('Filled Reqs'!$R$2:$R$386,"="&DATE(2007,8,1),'Filled Reqs'!$T$2:$T$386)-SUMIF('Filled Reqs'!$R$2:$R$386,"="&DATE(2007,9,1),'Filled Reqs'!$T$2:$T$386) I need to break this down further by department. when I add the SUMIF command before the last node('Filled Reqs'!$T$2:$T$386) to be included as an additional check (for a specific dept within a give month add the total days), It doesn't work. I don't get the right results, syntax errors, unbalanced (), I'm getting them all. Please advise Thanks, Ralph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of days in a running period | Excel Worksheet Functions | |||
| Can I calculate the number of days taken off in a running period | Excel Worksheet Functions | |||
| Calculating Working Days - Department of Pathology | Excel Discussion (Misc queries) | |||
| Finding number of particular days in a period | Excel Worksheet Functions | |||
| Calculating interest on number of days in the period | Excel Worksheet Functions | |||
Hybrid Mode
