How do I add formulas from sheet to sheet within the same workboo.

R

Ragdyer

Enter the name of the sheet that the cell is in, in front of the cell
reference.

For example, with this formula on Sheet1,
to add A1 from Sheet1 to C1 from Sheet2:

=A1+Sheet2!C1
OR
=SUM(A1,Sheet2!C1)
 

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

Finding the proper style field and the numbered paragraph value within the style 0
Autonumber field in Excel that behaves the same as Access 0
CountIf from multiple sheets in another workbook 4
comparing sheet to sheet and adding value 1
Sumif apllying to all sheets in workbook 2
I want to add formulas from multiple sheets to master form 1
Finding the right style field in VBA 0
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2

Top