Can anyone help me do this when the range is across worksheets? I have a
worksheet for each month, each row in an invoice with the amount in column I
and the date payment was posted in column M. I want to total the payments
made by date posted, so they could be on previous worksheets.

"Andrew" wrote:

I have a summary sheet where I want to know show the sum of all invoices paid
per month. In the "invoices" sheet I enter the invoices, the amount, data
paid etc.

I have tried to use sumif and, for the criteria, used dates as a serial
number to select any date range that is of interest.

Gives me an error and I'm out of ideas.

Andrew