Cell referencing and formulas

[Excelled]

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

 

[Cosmos75]

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

 

[lenze]

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

 

[Excelled]

cooooool......folkssss..thanks