Spreadsheet: 101441d1299565252-adjustable-count-function-contamesi
Sheet: Sheet1

1989-01-03 00:00:00 |  |  | Start Year: | 1989 | 1989-01-01 00:00:00
1989-01-30 00:00:00 |  |  | End Year: | 2010
1989-02-27 00:00:00
1989-04-03 00:00:00
1989-05-01 00:00:00 |  |  | #ofMonths: |  |  |  | For ex., say I input 1991 in the start year and 2000 in the "end year".  How can I get the count function to count the months just in those years?
1989-06-05 00:00:00
1989-07-03 00:00:00
1989-07-31 00:00:00
1989-09-05 00:00:00
1989-10-02 00:00:00
1989-10-30 00:00:00
1989-12-04 00:00:00
1990-01-02 00:00:00 |  |  |  |  |  |  | SUMPRODUCT(($A$1:$A$8="Tree Sale")*(MATCH($A$1:$A$8&$D$1:$D$8,$A$1:$A$8&$D$1:$D$8,0)=ROW($D$1:$D$8)))
1990-02-05 00:00:00
1990-03-05 00:00:00 |  |  |  |  |  |  | Hi,
1990-04-02 00:00:00
1990-04-30 00:00:00 |  |  |  |  |  |  | I was wondering if it's possible to make a count function that only counts stuff limited to a range based on what the user inputs. For example: say I have a time series that's twenty years long. I want a count function that counts how many months are in the time frame that the user specifies. For some reason I couldn't get a COUNTIFS function to work. I've attached a spreadsheet that hopefully makes things clearer.
1990-06-04 00:00:00
1990-07-02 00:00:00 |  |  |  |  |  |  | Thanks,
1990-07-30 00:00:00 |  |  |  |  |  |  | MofB
1990-09-04 00:00:00
1990-10-01 00:00:00
1990-11-05 00:00:00
1990-12-03 00:00:00
1990-12-31 00:00:00
1991-02-04 00:00:00
1991-03-04 00:00:00
1991-04-02 00:00:00
1991-04-29 00:00:00
1991-06-03 00:00:00
1991-07-01 00:00:00
1991-08-05 00:00:00
1991-09-03 00:00:00
1991-09-30 00:00:00
1991-11-04 00:00:00
1991-12-02 00:00:00
1992-01-06 00:00:00
1992-02-03 00:00:00
1992-03-02 00:00:00
1992-03-30 00:00:00
1992-05-04 00:00:00
1992-06-01 00:00:00
1992-06-29 00:00:00
1992-08-03 00:00:00
1992-08-31 00:00:00
1992-10-05 00:00:00
1992-11-02 00:00:00
1992-11-30 00:00:00
1993-01-05 00:00:00
1993-02-01 00:00:00
1993-03-01 00:00:00
1993-04-05 00:00:00
1993-05-03 00:00:00
1993-06-01 00:00:00
1993-07-06 00:00:00
1993-08-02 00:00:00
1993-09-07 00:00:00
1993-10-04 00:00:00
1993-11-01 00:00:00
1993-11-29 00:00:00
1994-01-03 00:00:00
1994-01-31 00:00:00
1994-02-28 00:00:00
1994-04-05 00:00:00
1994-05-02 00:00:00
1994-05-31 00:00:00
1994-07-05 00:00:00
1994-08-01 00:00:00
1994-09-06 00:00:00
1994-10-03 00:00:00
1994-10-31 00:00:00
1994-12-05 00:00:00
1995-01-03 00:00:00
1995-01-30 00:00:00
1995-02-27 00:00:00
1995-04-03 00:00:00
1995-05-01 00:00:00
1995-06-05 00:00:00
1995-07-03 00:00:00
1995-07-31 00:00:00
1995-09-05 00:00:00
1995-10-02 00:00:00
1995-10-30 00:00:00
1995-12-04 00:00:00
1996-01-02 00:00:00
1996-02-05 00:00:00
1996-03-04 00:00:00
1996-04-01 00:00:00
1996-04-29 00:00:00
1996-06-03 00:00:00
1996-07-01 00:00:00
1996-08-05 00:00:00
1996-09-03 00:00:00
1996-09-30 00:00:00
1996-11-04 00:00:00
1996-12-02 00:00:00
1997-01-06 00:00:00
1997-02-10 00:00:00
1997-03-10 00:00:00
1997-04-21 00:00:00
1997-05-05 00:00:00
1997-06-09 00:00:00
1997-07-08 00:00:00
1997-08-04 00:00:00
1997-09-08 00:00:00
1997-10-06 00:00:00
1997-11-10 00:00:00
1997-12-08 00:00:00
1998-01-12 00:00:00
1998-02-09 00:00:00
1998-03-09 00:00:00
1998-04-06 00:00:00
1998-05-04 00:00:00
1998-06-08 00:00:00
1998-07-07 00:00:00
1998-08-10 00:00:00
1998-09-08 00:00:00
1998-10-05 00:00:00
1998-11-09 00:00:00
1998-12-07 00:00:00
1999-01-05 00:00:00
1999-02-08 00:00:00
1999-03-01 00:00:00
1999-03-29 00:00:00
1999-05-03 00:00:00
1999-06-01 00:00:00
1999-06-28 00:00:00
1999-08-02 00:00:00
1999-08-30 00:00:00
1999-09-27 00:00:00
1999-11-01 00:00:00
1999-11-29 00:00:00
2000-01-03 00:00:00
2000-01-31 00:00:00
2000-02-28 00:00:00
2000-04-03 00:00:00
2000-05-01 00:00:00
2000-05-30 00:00:00
2000-07-03 00:00:00
2000-07-31 00:00:00
2000-08-28 00:00:00
2000-10-02 00:00:00
2000-10-30 00:00:00
2000-11-27 00:00:00
2001-01-02 00:00:00
2001-01-29 00:00:00
2001-02-26 00:00:00
2001-04-02 00:00:00
2001-04-30 00:00:00
2001-05-29 00:00:00
2001-07-02 00:00:00
2001-07-30 00:00:00
2001-09-04 00:00:00
2001-10-01 00:00:00
2001-10-29 00:00:00
2001-12-03 00:00:00
2001-12-31 00:00:00
2002-01-28 00:00:00
2002-02-25 00:00:00
2002-04-02 00:00:00
2002-04-29 00:00:00
2002-06-03 00:00:00
2002-07-01 00:00:00
2002-07-29 00:00:00
2002-09-03 00:00:00
2002-09-30 00:00:00
2002-10-28 00:00:00
2002-12-02 00:00:00
2002-12-30 00:00:00
2003-02-03 00:00:00
2003-03-03 00:00:00
2003-03-31 00:00:00
2003-04-28 00:00:00
2003-06-02 00:00:00
2003-06-30 00:00:00
2003-07-28 00:00:00
2003-09-02 00:00:00
2003-09-29 00:00:00
2003-11-03 00:00:00
2003-12-01 00:00:00
2003-12-29 00:00:00
2004-02-02 00:00:00
2004-03-01 00:00:00
2004-03-29 00:00:00
2004-05-03 00:00:00
2004-06-01 00:00:00
2004-06-28 00:00:00
2004-08-02 00:00:00
2004-08-30 00:00:00
2004-09-27 00:00:00
2004-11-01 00:00:00
2004-11-29 00:00:00
2005-01-03 00:00:00
2005-01-31 00:00:00
2005-02-28 00:00:00
2005-03-29 00:00:00
2005-05-02 00:00:00
2005-05-31 00:00:00
2005-06-27 00:00:00
2005-08-01 00:00:00
2005-08-29 00:00:00
2005-10-03 00:00:00
2005-10-31 00:00:00
2005-11-28 00:00:00
2006-01-03 00:00:00
2006-01-30 00:00:00
2006-02-27 00:00:00
2006-04-03 00:00:00
2006-05-01 00:00:00
2006-05-30 00:00:00
2006-07-03 00:00:00
2006-07-31 00:00:00
2006-08-28 00:00:00
2006-10-02 00:00:00
2006-10-30 00:00:00
2006-11-27 00:00:00
2007-01-03 00:00:00
2007-01-29 00:00:00
2007-02-26 00:00:00
2007-04-02 00:00:00
2007-04-30 00:00:00
2007-05-29 00:00:00
2007-07-02 00:00:00
2007-07-30 00:00:00
2007-09-04 00:00:00
2007-10-01 00:00:00
2007-10-29 00:00:00
2007-12-03 00:00:00
2007-12-31 00:00:00
2008-01-28 00:00:00
2008-03-03 00:00:00
2008-03-31 00:00:00
2008-04-28 00:00:00
2008-06-02 00:00:00
2008-06-30 00:00:00
2008-07-28 00:00:00
2008-09-02 00:00:00
2008-09-29 00:00:00
2008-11-03 00:00:00
2008-12-01 00:00:00
2008-12-29 00:00:00
2009-02-02 00:00:00
2009-03-02 00:00:00
2009-03-30 00:00:00
2009-04-27 00:00:00
2009-06-01 00:00:00
2009-06-29 00:00:00
2009-08-03 00:00:00
2009-08-31 00:00:00
2009-09-28 00:00:00
2009-11-02 00:00:00
2009-11-30 00:00:00
2009-12-29 00:00:00
2010-02-01 00:00:00
2010-03-01 00:00:00
2010-03-29 00:00:00
2010-05-03 00:00:00
2010-06-01 00:00:00
2010-06-28 00:00:00
2010-08-02 00:00:00
2010-08-30 00:00:00
2010-09-27 00:00:00
2010-11-01 00:00:00
2010-11-29 00:00:00