Counting with multiple conditions

**Littleoladywho** · 09-19-2007, 03:47 PM

I am trying to make an array that will count houses based on their size and year built. My worksheet contains the following columns: A - Sale Date; B - Sale Price; C - Size; D - Year Built. I cannot get a formula to work that will count a house if it is built before 1960 and is less than 1000 square feet in size.

The second problem will be when I try to build a formula to count houses built between 1960 and 1969 and less than 1000 square feet.

I am using Mac Excel 2004. Any thoughts?
Littleoldladywho

**VBA Noob** · 09-19-2007, 04:02 PM

Try

=SUMPRODUCT(--(C2:C100<=900)*(C2:C100>0))*(D2:D100<1960)*(D2:D100>0)

and

=SUMPRODUCT(--((D2:D100<=1969)*(D2:D100>=1960)*(C2:C100<=1000)*(C2:C100>0)))

VBA Noob

**Littleoladywho** · 09-19-2007, 04:29 PM

The second formula works perfectly. The first returns "0" when it should return "1." I fixed the last cell reference with no success in the results. Is this an issue with parenthesis placement?

Thanks,
Littleoldladywho