Here's an implemented sample, adapted to suit:
http://www.freefilehosting.net/download/3bail
Summarizing_Tanya.xls
With the "date" sheets' sheetnames listed in D1 across (Entered as real dates)
In D2, copied across/fill down:
=SUMIF(INDIRECT("'"&TEXT(D$1,"m-dd-yy")&"'!E:E"),$A2,INDIRECT("'"&TEXT(D$1,"m-dd-yy")&"'!D:D"))
Then in B2, copied down: =SUM(D2:F2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tanya" wrote:
I only want the mail date and total check amount on the summary page. Not
all of the columns. I am trying to keep it simple for the users. If we had
to put a column for every check sheet on each month it would get to large.
The check date sheets have other information on them also that is not used
in the summary. And a check mail date could cover several date sheets.
I put a sample of the sheet on here
http://www.freefilehosting.net/download/3bahc
Summarizing1.xls
Thank you for your help
Tanya