# Cell referencing and formulas

#### Excelled

##### New Member
I have a an excel file with three worksheets - sheet1, sheet2 and sheet3. I plan to find some totals on sheet3 using values from both sheet1 and sheet2.

Sheet 1:
a1= 1, b1=2, c1=4
a2=10, b2=24, c3=6
Sheet 2:
a1= 2, b1=15, c1=33
a2=67, b2=2, c2=34

a1 on sheet3 grabs the a1 values from sheet1 and sheet2 and adds them together
Sheet3:
a1=Sheet1!\$A\$1 + Sheet2!\$A\$1

How can i get the other cells on sheet3 such as b1, c1, a2, b2, c2 etc to display such results as A1. When I click and drag, it points to the same values as the a1 field and does not change to a2=Sheet1!\$A\$2 + Sheet2!a\$2. Is there an easy way to correct this referencing issue?

Pleasee let me knoww..I appreciate it..Thanks
This message was edited by Excelled on 2002-08-23 09:58

### Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
A \$ in front of the Column reference (\$A1) in a cell reference keeps that column constant when you copy to another cell, where without the \$ the cell reference would change reletave to how many columns you move over and paste the formula with the cell reference.

Same logic applies to \$ in from of the cell row reference (A\$1).

Take out the \$s' and see what happens.

Play around with leaving only the column \$ there and see what happens and then leave only the row reference and see what happens!

Hope this helps!

This message was edited by Cosmos75 on 2002-08-23 10:03

Your sheet 3 Cell A1 has Absolute cell references. Remove the \$ signs from the formula and then copy it

cooooool......folkssss..thanks

Replies
7
Views
242
Replies
1
Views
51
Replies
0
Views
56
Replies
6
Views
268
Replies
2
Views
190

1,203,353
Messages
6,054,916
Members
444,759
Latest member
TeckTeck

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back