I need to count a cell if another cell is in a particular year. For example:
Column S has dates in this format (May-05). The dates range from Jan-96 to
Aug-05. The numbers to be added are in column W. So, I need a formula that
will calcuate a total for 1996, 1997, 1998, through 2005.