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