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

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

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

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