COUNTIF using multiple conditions?
 

Hello folks - would appreciate help with this, please!

I'm setting up a summary sheet to help track housing for a conference.
For each date I have a formula to track the number of rooms, i.e. for
January 7: =COUNTIF('Housing
List'!F:F,"1/07/2005")+B4-(COUNTIF('Housing List'!G:G,"1/07/2005"))

This counts the number of people arriving on the 7th, plus the number
people already arrived prior, minus anyone leaving on the 7th.

So now I need to break it down further, and use that same formula but
only count the single rooms, so the ones with "Single" in column H (and
then I need to do the same with Doubles).

How can I add that extra condition?

And THEN - oh this gets fun - I need to break it down one step further
and count the number of people from a particular group (code is in
column A) who have doubles for a particular night, and then for the
same group the number who have singles.
Please help!! :-)

Christina - Muse of Fire

Hi
use SUMPRODUCT. See:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

Muse of Fire wrote:
Hello folks - would appreciate help with this, please!

I'm setting up a summary sheet to help track housing for a conference.
For each date I have a formula to track the number of rooms, i.e. for
January 7: =COUNTIF('Housing
List'!F:F,"1/07/2005")+B4-(COUNTIF('Housing List'!G:G,"1/07/2005"))

This counts the number of people arriving on the 7th, plus the number
people already arrived prior, minus anyone leaving on the 7th.

So now I need to break it down further, and use that same formula but
only count the single rooms, so the ones with "Single" in column H
(and then I need to do the same with Doubles).

How can I add that extra condition?

And THEN - oh this gets fun - I need to break it down one step further
and count the number of people from a particular group (code is in
column A) who have doubles for a particular night, and then for the
same group the number who have singles.
Please help!! :-)

Christina - Muse of Fire

Thank you for the tip - but I'm still having trouble!

To count those arriving on 1/5/05 who have single rooms, I put:

=SUMPRODUCT(('Housing List'!F:F="1/05/2005")+('Housing
List'!H:H="Single"))

But it's returning a #NUM! error on both arrays???? I keep rereading
that website, but can't figure out what I'm doing wrong in my array???
Please help! Thank you :-)

Christina - Muse of Fire

Hi
try
=SUMPRODUCT(--('Housing List'!F1:F1000="1/05/2005"),--('Housing
List'!H1:H1000="Single"))

--
Regards
Frank Kabel
Frankfurt, Germany
"Muse of Fire" schrieb im Newsbeitrag
ups.com...
Thank you for the tip - but I'm still having trouble!

To count those arriving on 1/5/05 who have single rooms, I put:

=SUMPRODUCT(('Housing List'!F:F="1/05/2005")+('Housing
List'!H:H="Single"))

But it's returning a #NUM! error on both arrays???? I keep rereading
that website, but can't figure out what I'm doing wrong in my array???
Please help! Thank you :-)

Christina - Muse of Fire