add number of days within a department for a given time period

G

Guest

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
 
T

T. Valko

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

is there an easier/faster way to do what I'm doing in 3 steps 11
counting the occurances for specific dept within a given time peri 1
Within another function calculate and sum number of days 6
Formula to get number of days excluding Fridays in a given period 17
number of week days in a period of time 5
calculating number of days belonging to each month within a given week 2
How do I count the number of events in a 90 day period? 2
Can I calculate the number of days taken off in a running period 1

Top