Create formula that combines numbers from multiple workBOOKS?

S

Sarah@LaborSource

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - different figures returned?! 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
sumproduct with COUNTIF With An INDIRECT 1
formula between two workbooks 1
pulling data from multiple workbooks 3
multiple workbooks in one file 3
Link future workbooks to a summary workbook... 1
formula correction in multiple workbooks 0

Top