How do I add and/or substract numbers from different worksheets?
R Ragdyer Sep 12, 2004 #2 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)
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)
