Hi Al

not sure exactly how you want the quarterly reports arranged but i'm
assuming that you've got the same columns on this report as you have on the
weekly report and what you want to see is:
.............A.......................B.......................C................................D..........................
1.........QTR...............Category1..............Category2..................Category3.........
2.........1st..................=SUMPRODUCT(--(WeeklySheet!$A$2:$A$54>DATEVALUE("1/1/2005")),--(WeeklySheet!$A$2:$A$54<DATEVALUE("31/3/2005")),WeeklySheet!B$2:B$54)

the formula in B2 can then be filled across to columns C, D, E etc
and down for other quaters, just change the values in the DateValue part of
the formula.

BTW WeeklySheet needs to be replaced with the actual sheet name of your
weekly numbers - if the sheet name contains a space you'll have to enclose
it in ' '

Cheers
JulieD

"Al Vanderhoof" <calldpi@tds.net> wrote in message
news:420beba5$1_1@newspeer2.tds.net...
>I have a workbook that has 52 weeks(rows) of income and expenses(columns).
> I'm trying to set up a quarterly reports sheet that updates from this
> info, but I cannot figure out how to set up the formulas that will find
> the dates that are in the range and save the subtotals and totals.
> Thanks ahead of time for any help
>