open ended multi page sum

A

AlZee

Ragdyr: Thanks, but the problem is that I have ONE sheet on each o
many (unknown quantity) of workbooks that have to be summed to on
master summary page on the master workbook. The name of the workshee
on all the sub-workbooks will be the same. The "sum" command does no
appear to work across workbooks. If I knew the number of workbook
ahead of time I could build =workbook1()+workbook2()...etc up to th
number of workbooks. Not knowing the number I cannot preset it, and i
I use workbook numbers when that workbook does not exist it will no
work
 
R

Ragdyer

Post back with the FULL path and names of your existing WBs, similar to
this:

='f:\PHOENIX\ORDER\[45251.XLS]DYEORDER'!$J$10

I *might* be able to give you a formula and procedure to enable you to
access your existing and "not yet" existing WBs.

Regards,

RD
 

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

dragging formula is giving me undesired result in cell calls. 0
Multiple Tables and Multiple Pivot Tables Help 0
Excel - different figures returned?! 0
SUM function across multiple worksheets within one workbook 4
open ended multi page sum 2
Using VB to pull formats and data from another workbook 0
COUNTIF FUNCTION 6
vlookup across multiple pages 2

Top