m17347047711116
New Member
- Joined
- Aug 28, 2002
- Messages
- 7
O.k
Heres what i need to do
Sheet 1 Master Schedule
[Name][Department][D"Start Time"]
Sheet 2
[AA "StartBin"] [#of started at this time]
Works great using SumProduct Function but it counts all the people who started at a specified time.
"=SUMPRODUCT(($D$6:$D$12>=AA5)*($D$6:$D$12<AA6))"
D = my Start Time array
AA= my Start Time Bin
The problem is that i do not want to sumproduct for all start times only for start times that meet the Department criteria
Heres what i need to do
Sheet 1 Master Schedule
[Name][Department][D"Start Time"]
Sheet 2
[AA "StartBin"] [#of started at this time]
Works great using SumProduct Function but it counts all the people who started at a specified time.
"=SUMPRODUCT(($D$6:$D$12>=AA5)*($D$6:$D$12<AA6))"
D = my Start Time array
AA= my Start Time Bin
The problem is that i do not want to sumproduct for all start times only for start times that meet the Department criteria