entering formulas involving 2 workbooks
 

I have a workbook titled "weekly totals" and would like the final total to
appear in a workbook titled "monthly totals". Could anyone provide the
formula?
Thank you

entering formulas involving 2 workbooks
 

In a cell type =
open the other workbookpoint to the cellhit enter

--
Don Guillett
SalesAid Software

"marysea" wrote in message
...
I have a workbook titled "weekly totals" and would like the final total to
appear in a workbook titled "monthly totals". Could anyone provide the
formula?
Thank you

entering formulas involving 2 workbooks
 

Open both workbooks, in the monthly totals workbook, click the cell where you
want the weekly total to be. type the equal sign, click the weekly totals
workbook and the cell that contains the total. Click the check mark on the
formula bar.
The formula will look like:
=[filename]sheetname!celladdress
you could type it, but it's way easier to click!

"marysea" wrote:

I have a workbook titled "weekly totals" and would like the final total to
appear in a workbook titled "monthly totals". Could anyone provide the
formula?
Thank you

entering formulas involving 2 workbooks
 

Open the two files
In a cell in Monthly type =
Move to the Weekly file and click on the cell whose values is needed
Press enter
You will get a formula such as
='[Weekly Totals.xls]Sheet5'!$B$6
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"marysea" wrote in message
...
I have a workbook titled "weekly totals" and would like the final total to
appear in a workbook titled "monthly totals". Could anyone provide the
formula?
Thank you