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