Try

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


--

HTH

RP
(remove nothere from the email address if mailing direct)


"cyberindio" wrote in message
...
Thanks Biff, but I can't seem to get it to work. I get a "0" answer when
there have to be at least 1500 records that fit the criteria. I used the
exact syntax you gave me but it might be multiplying zeros.

"Biff" wrote:

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