Try this:

Assumes no empty cells in your acreage column.

=SUMPRODUCT(--(Data!E2:E600<1),--(Data!F2:F600DOS1))

--
Biff
Microsoft Excel MVP


"Larry Smith" wrote in message
...
I have a table of data with a date column and an acreage column. I want to
count how many parcels of less than 1 acre have sold within the past 6
months. I set a field with the date from which I want to start counting
(named it DOS1) the used the follow formula:
countif(Data!f2:f600,"&DOS1).
That returns the number of sales after the DOS1 date to current date.
Question is this: how do I then modify the formula to get only those sales
of
less than 1 acre listed in Data!E:E??? I using Excel 2002.
--
LarryJasper