Create formula that combines numbers from multiple workBOOKS?
 

Can I create formulas that combine values from multiple workbooks (NOT just
worksheets within the same book).

For example, I want the total sales from Workbooks 1,2, 3, and 4 to be
summed up in Workbook 5.

Create formula that combines numbers from multiple workBOOKS?
 

Hi
Take a look at Ron web

http://www.rondebruin.nl/copy3.htm

if this helps please click yes

"Sarah@LaborSource" wrote:

Can I create formulas that combine values from multiple workbooks (NOT just
worksheets within the same book).

For example, I want the total sales from Workbooks 1,2, 3, and 4 to be
summed up in Workbook 5.