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.


=SUMPRODUCT(((H1:H10="HOUSES")+(H1:H10="CONDOS")+( H1:H10="Apartments"))*(I1:I10="Alabama"))