=SUMPRODUCT(--(MONTH(A2:A20)=1,B2:B20)

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"BillMcSweeney" wrote in message
...
How do I fill out a table with month totals from an unsortable series of
entries by date. These are individual wages by date and I want to know
what
the total wages bill is by month. I have tried SUMIF but am stuck on the
criteria.