If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formulas
I have entered the formula in sheet "A". I want to bring a
total of several cells from sheet "b". The page is not adding the cells from page "b", instead it takes the cells in page "A". My formula looks like this. What am I doing wrong? =+B!m12+o12+r12 Is there anyway to copy that formula and have the number change by 2 digits each time? |
#2
|
|||
|
|||
formulas
Hi Kay,
Try this formula: =SUM(B!M12,B!O12,B!R12) The copy would work if you copy it two rows down. Biff -----Original Message----- I have entered the formula in sheet "A". I want to bring a total of several cells from sheet "b". The page is not adding the cells from page "b", instead it takes the cells in page "A". My formula looks like this. What am I doing wrong? =+B!m12+o12+r12 Is there anyway to copy that formula and have the number change by 2 digits each time? . |
Thread Tools | |
Display Modes | |
|
|