Bill,

Prefered method:

Use a Pivot table, with the dates as the row fields, and then group by date. No formulas involved.

Or, use a formula like

=SUMPRODUCT((MONTH(C3:C25)=2)*D3:D25)

where column C has the dates, and D the numbers, and you want February results.
(This could be modified to make a table by using

=SUMPRODUCT((MONTH($C$3:$C$25)=G2)*$D$3:$D$25)

Where G2 has a month number, and the numbers continue down column G...

Another method.

Use a helper column with the formula

=MONTH(cell with date)

and base the SUMIF on that column.



HTH,
Bernie
MS Excel MVP


"BillMcSweeney" wrote in message
...
I have tried using SUMIF but am stuck in 'criteria'. I have two columns with
week date and amount for each employee. I want to total and show the totals
for each month.