|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Countif
--
LarryJasper
"Rick Rothstein (MVP - VB)" wrote:
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 am using Excel 2002.
Not sure what the was about... so I assumed you meant = in the following
formula (which I believe does what you want):
=SUMPRODUCT((Data!F2:F600=DOS1)*(Data!E2:E600<1))
Rick
Why would you Multiply these 2 numbers?? I want just a count meeting both conditions 1)Greater than DOS1 2)Less than 1 (acre). Both condition must be met.
|