Combining two COUNTIFS

**fletch8701** · 07-18-2012, 09:13 PM

Hi, New to this forum.

I'm having a problem combining two equations in a COUNTIFS formula. I have a list of data reflecting when residents arrive and from the residence hall I work in & the room numbers they are living in. I am trying to use COUNTIFS to show the number of beds that are occupied in a given room reflective of the current date. I have two equations that work on their own =COUNTIF(K1:K3000, "=111") where 111 is the room number and =COUNTIF(N1:N3000, ">="&A2) where A2 contains the current date.

The range K1:K3000 are room numbers & N1:N3000 are the dates of departure for the students. I am trying to make this count how many people are still in each room with =COUNTIFS(K1:K3000, "=111", N1:N3000, ">="&A2).....but it's not working.

Help!

Thanks!!

**jeffreybrown** · 07-18-2012, 11:46 PM

Hello & Welcome to the Forum,

I see your profile says 2003 and if this is so, COUNTIFS would not work as it is only for 2007+

If you do actually have 2007+, this works for me...

Formula:

Please Login or Register  to view this content.

If you are using 2003, try...

Formula:

Please Login or Register  to view this content.

**fletch8701** · 07-19-2012, 09:12 PM

Thank you soo much! It's working now. This will help me out soo much.

Thanks again

**jeffreybrown** · 07-19-2012, 11:07 PM

You are most welcome. Glad it worked out for you and thanks for the feedback

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save