Sat, 14 Jul 2007 13:12:00 -0700 from Larry Smith
:
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.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/