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
|
|||
|
|||
Formula problems
I am having a problem with my formula changing all of the
sudden. For example, I have columns A1 through A20 A21 is adding columns A1 thru A7 =SUM(A1:A7) A22 is addding columns A8 thru A10 and A14 thru A20 =SUM(A8:A10,A14:A20) A23 is adding columns A11 thru thru A13 =SUM(A11:A13) The problem is that cell A21 is all of the sudden adding cells A1 thru A20,when I really want it to add A1 thru A7 I have changed it back a million times and cannot figure out why it keeps reverting back to add the whole row. I have used this formula for the past year and now I am having this problem. What could I be doing wrong. |
Thread Tools | |
Display Modes | |
|
|