Hello:

Can you provide any additional detail about how the data in the Weekly
Totals workbook is structured? Are the weeks by column or by row?

Also, when you say workbook, are these two worksheets in the same file or
in different files?

Cheers.

"marysea" wrote:

I have 2 workbooks, Weekly Totals and Monthly Totals. I would like the sum
of each week in Weekly Totals (week 1, week 2, week 3, week 4, week 5) to
appear in the workbook Monthly Totals. Some of the Weekly Total catagories
are $ amounts and some are #' of patients. Does anyone know the formula for
each catagory?