linking

  • Thread starter Thread starter timothy
  • Start date Start date
T

timothy

how do you link sheets together, like i have i the totals in 5 or 6
different sheets and on the last sheet i want the grand total. i need help!!
 
Its pretty simple!

You can simply write a formula which looks like this
=SUM(Jan:Apr!D3)

where, Jan, Feb, Mar and Apr are 4 sheets and i am writing the formula
in another sheet named Total.

If your data is exaly on the same location in all sheets, you can
simply use this formula instead of saying =Jan!B4+Feb!B4+Mar!B4+Apr!B4

Hope this helps.
 
Back
Top