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