Linking Totals Across Multiple Worksheets

S

snowboardbaltimore

I am trying to sum the totals (in accounting number format) across multiple
worksheets onto a single worksheet. I have tried manually creating the
necessary formula (='ex1'!c19+'ex2'!c19+'ex3'!c19+....), and also copying th
formula from a previous worksheet. No matter how I do this, the formula stays
visible and does not calculate or become anything more than text. Is there
any other way to sum across multiple pages?
 
T

T. Valko

Make sure the cell with the formula is formatted as GENERAL at first. Enter
your formula *then* change the format if you'd like.

Try this formula:

=SUM('EX1:EX3'!C19)
 
S

snowboardbaltimore

Thank you very much, that solved the problem for most of the formulas. I am
not sure how they got adjusted to textw hen the rest of the document (and the
ones they were originally written in and copied from) are in "Accounting" and
"General". now, I just have to figure out the rest of them.

But, thank you for the great help and making me aware.
 

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

Adding same cells across multiple worksheets 2
Vlookup - multiple tabs 5
SUMif or SUMproduct across multiple worksheets? 1
SUM function across multiple worksheets within one workbook 4
Conditional SUM across multiple worksheets 0
summarise totals from many worksheets into one final worksheet 3
Lookup wordstring across mulitple worksheets & return sums 6
Sum uniques values on multiple worksheets 9

Top