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