| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| COUNTIF | Excel Worksheet Functions | |||
| edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Threaded Mode
