Calculate How Many People Are Working At The Same Time using the COUNTIFS Function

I'm trying to utilize the COUNTIFS function to see how often certain meeting rooms are being used throughout the day. I found an example online (noob, can't post link yet but it's from howtoexcelatexcel) that uses number of employees working, but I think I should be able to use it:


However, I can't get that example to work - the "Working Hours" on my sample always equals zero. I even tried making a copy of their example, and I'm still getting zeros. If someone could let me know what I'm getting wrong I'd appreciate it.

Try this, copied down:

=SUMPRODUCT(--(G6>=C$6:C$20),--(G6<D$6:D$20))

My www just went down... again... in Fuerteventura, off the W coast of Africa.

Here's your file which didn't upload.

Here is another way.

Formula:

Please Login or Register  to view this content.

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.