1. ## Count problem (2003)

Hi Everyone,

I am trying to find out how many customers are in the department at any one time, there arrival time being between x and y (15 min blocks) and there departure time being z

=SUMPRODUCT((\$D\$6:\$D\$39>=J\$5)*(\$D\$6:\$D\$39<J\$6)) this works for doing a count of customers by 15 min blocks but does not cumulatively count customers who arriaved before and have not yet departed.

J5 = Arrival Time start range
J6 = Arrival time end range

{=SUMPRODUCT((\$D\$6:\$D\$39>=J\$5)*(\$D\$6:\$D\$39<J\$6)*(\$ F\$6:\$F\$39>J\$5)} - This did not work but column F contains the departure times

Many thanks

2. ## Re: Count problem (2003)

Could you post a small sample workbook?

Thanks

Here you go

4. ## Re: Count problem (2003)

In J7:

=SUMPRODUCT((\$D\$6:\$D\$39<=J6)*(\$F\$6:\$F\$39>=J5))

This is a 'normal' formula, not an array formula.

5. ## Re: Count problem (2003)

Hi,

Thanks Hans, I was definatly making it more complicated than it needed to be! I had found another formular that worked using a sumproduct + sumproduct but your way is much cleaner, thanks

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•