- Feb 16, 2005
- 3,617
- 2
- 81
I have a spreadsheet where it calculates a total of a few cells.
i.e. SUM(B1:e1)
The problem is that when I enter a value (manually) in f1, it'll automatically change the formula to SUM(B1:F1) which I have to manually change it again. Anybody seeing this problem and know of a fix?
i.e. SUM(B1:e1)
The problem is that when I enter a value (manually) in f1, it'll automatically change the formula to SUM(B1:F1) which I have to manually change it again. Anybody seeing this problem and know of a fix?
Facebook
Twitter