Glenn wrote:
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"))


Or this:

=SUMPRODUCT(((H1:H10={"HOUSES","CONDOS","Apartment s"}))*(I1:I10="Alabama"))