Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
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 in one cell 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? (money and numbers) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
You'd need to use the SUM formula, but both workbooks would need to be open
at the same time for it to work properly. It would be much easier if the monthly and weekly totals were on different worksheets within the workbook. "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 in one cell 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? (money and numbers) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
marysea
You had several answers to this question when you posted it earlier. Are you not seeing these responses? Gord Dibben MS Excel MVP On Sat, 19 May 2007 16:35:01 -0700, 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 in one cell 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? (money and numbers) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|