First the spreadsheet we are talking about here was created in Excel '97 and
I am now using Excel 2003.
In each row I have a formula in column P that sums cells in the I & J
columns.
Ex.(=SUM(I1:J1)

I am having a problem when I am filling out a row and enter something into
the cell in the I column then enter a figure into the K COLUMN it is changing
the fomula in column P to =SUM(I1:K1). IN OTHERWORDS, IT IS NOW INCLUDING
THE CELL IN COLUMN K.
Now, what is even more interesting is when I don't enter anything in to I
column but enter something into J column it doesn't change the formula. It
only changes the formula when I make an entry into the I column cells. And
it only changes when I fill the row from left to right (A1,B1,C1,ETC) AND
WHEN I ENTER THE FIGURE INTO THE K COLUMN CELL. THAT IS WHEN THE FORMULA
CHANGES IN THE P COLUMN TO INCLUDE THE K COLUMN CELL.
HELP!!! What is going on here?