Hi I am new to this forum.
Can you help me with a problem.
I was given an inventory in a spreadsheet. My experience with Excel is
limited, but I am a quick learner.
Here is my problem.
I have a column that should have formulas as follows:
=SUM(A1:F1)
the two cells are always supposed to be on the same row.
Somehow in the middle of the column I find this happenning:
=SUM(A234:f236)
the rest of the column formulas are offset by two row values.
Is there any easy way to edit this enite spreadsheet without having to
actually edit each individual cell?
Thank You,
John


--
John K
------------------------------------------------------------------------
John K's Profile: http://www.excelforum.com/member.php...o&userid=34726
View this thread: http://www.excelforum.com/showthread...hreadid=544910