Linking worksheets with a formula

  • Thread starter Thread starter Dorothy Babel
  • Start date Start date
D

Dorothy Babel

I have a set of worksheets that are invoices. I want a
certain cell totaled on the total sheet. I keep getting
errors. Each work sheet has a Spanish name ie (Maria's
Fashion1). I am using (='Maria's Fashion1'!d4+) the
formula worked on the first two pages. I have 35 pages to
link. Could anyone help????
 
I doubt the Spanish name has any bearing on your problem. If all the data is
in the same cell on each sheet, use =SUM(Sheet1:Sheet35!D$).

You can select all the sheets at once by typing in a blank =SUM( and click
on the first (left) sheet tab in the group, hold down the Shift key and
select the last (right) sheet tab in the group and type D4, then press
enter. You should see the total in the cell where you entered the formula.
 
Back
Top