Hi,

Here's another approache

=SUMPRODUCT((I1:I6=A1)*(H1:H6=B1:D1))

Where A1 contains Alabama, and B1:D1 your 3 types of housing.

direction is important.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Lime" wrote:

This has to be easy...
column "J" I need to count how many times "Alabama" shows in column "I" only
if column "H" = either "HOUSES" or "CONDOS" or "Apartments"

ANy help would be appreacited.