OS: Windows XP Professional
Ver: Office 2000

I have two worksheets. The first worksheet has daily information where
each row represents a single day, the first column holds the label for
that day. (Hope example shows up correctly)

SHEET 1
A B C D E F G H
01/03/07 Wed 24,524 15,104 4,570 2,088 9,045 86.18%
01/04/07 Thu 55,823 40,528 10,737 4,956 8,711 87.77%
01/05/07 Fri 78,211 58,089 7,731 3,893 6,823 93.30%
01/08/07 Mon 50,584 36,082 16,478 8,612 4,931 76.13%
01/09/07 Tue 54,437 34,800 5,840 2,725 7,498 92.17%



The second worksheet is to be a monthly totals page. It will basically
be an exact duplicate of the first sheet, except each row will represent
an entire month and column A will hold the labels accordingly.

SHEET 2
A B C
Jan-07 sum column C of sheet 1 where
month and year of column A
of sheet 1 = month and year
of A for current row
Feb-07
Mar-07


I want to have this worksheet calculate solely using the daily data
entered on sheet 1. The problem I'm having is identifying month AND
year in criteria. This is extremely important because we have a couple
of years of data in the data source and will continue adding to it for
some time.



Any help provided is greatly appreciated!!


Rita Palazzi
Project Engineer /Global Trade Services
FedEx Express