Veronica,

With 12 dates in A1 to A12 each of which are the months you want i.e
1/1/2008
1/2/2008
..
..
..
1/12/2008

Put this in b1 and drag down to b12
=SUMPRODUCT(--(MONTH(Sheet2!A1:A30)=MONTH(A1)),--(Sheet2!B1:B30))
The will look on Sheet 2 a1 to a30 for the month in column A and sum
corresponding cells in Column B. Extend the ranges as you require but they
must be the same length.

Mike
"Veronica Johnson" wrote:

I have 12 cells, one for each month of the year. I need each of the
cells to reference the dates on other worksheets in order to summarize
my data. For instance, my profit summary should show the profit for
January in cell J8 of one worksheet, but only if the PO date on
another worksheet is in January. February should show the profit only
if the PO is in Feb, and so on. Probably a very easy task, but I
can't seem to find it in excel help. Can anybody help on this one?
Thank you in advance.