Hi!

Try this:

=SUMPRODUCT(--(A1:A100="House"),--(B1:B100="Vacant"))

Biff
"cyberindio" wrote in message
...
I have a table with a column that indicates if the record is for a "House"
or
an "Apartment" and a second column that indicates if it is "Occupied" or
"Vacant". How do I wite a formula to count all the houses that are vacant
?
--
cyberindio