sheets and formulas

  • Thread starter Thread starter Aleksi
  • Start date Start date
A

Aleksi

Hi,
I wish to enter formulas in a new worksheet using values from other
previously used ones. That is, if I have three different values- for eg.- in
one sheet, I wish to have their total in a new sheet using formula(s). In
other words, how do I link different sheets together in one document by
formulas.
Tnx
Alex
 
When writing your formula, you can simply select the cell from the sheet you
want to refer to, or the general format is
=SUM('Sheet1'!A1:A10)

Where the name of sheet you want to refer to is inside single quotation marks.
 
You must log in or register to reply here.

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

Copy a formula using Vlookup 2
Copy Exact Formula 1
Problem with formula in grouped sheets 2
Special Pasting a work book with many sheets and formulas 2
Same formula for each sheet? 4
applying COUNTIF formula across several sheets 4
Balance Sheet Formula 5
Complex formula help , please. 13

Back
Top