One way I'd set it up, Tanya ..

Illustrated in this sample:
http://www.freefilehosting.net/download/3b9jm
Summarizing.xls

Source "date" sheets are assumed named
in this unambiguous manner, eg: 02Feb2008, 03Feb2008

In Summary,
CheckMail dates assumed listed in A2 down
List the source "date" sheets in D1 across. Enter it as real dates

Place in D2:
=SUMIF(INDIRECT("'"&TEXT(D$1,"ddmmmyyyy")&"'!B:B") ,$A2,INDIRECT("'"&TEXT(D$1,"ddmmmyyyy")&"'!A:A"))
Copy D2 across/fill down as far as required. This easily extracts the total
amounts for each checkmail date (in B2 down) from each source date sheet, and
you know exactly what total amount is coming from which source date sheet.
Then you could just simply sum it all up in B2 down with: =SUM(D2:IV2).
Adapt/extend to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tanya" wrote:
I can't seem to figure this one out.

I have a sheet per check date and a summary sheet. In "check date" sheet,
there are two columns, A=check amount & B= check mail date. There can be
different amounts of rows per "check date" sheet.

On summary sheet, I want the total checks mailed on by date. This will
cross several "check date" sheets.

I can do it using just one sheet, but I don't know how to add the other
ranges.

Please help.
--
Tanya