Moving formula down 1 row if information is entered into column A
 

I am trying to find a way to move a formula down one row if information gets
entered into column A of the same row. Does anyone know how to do that? I am
trying to calculate the total of one column as we enter new information, but
don't want to keep entering the formula every time I enter a new row of
information. Any help we be greatly appreciated! Thanks!

Moving formula down 1 row if information is entered into column A
 

Hi,

Why not

=SUM(A:A)

Mike

"LinZ" wrote:

I am trying to find a way to move a formula down one row if information gets
entered into column A of the same row. Does anyone know how to do that? I am
trying to calculate the total of one column as we enter new information, but
don't want to keep entering the formula every time I enter a new row of
information. Any help we be greatly appreciated! Thanks!

Moving formula down 1 row if information is entered into column A
 

If I'm reading this correctly, your formula should not change if you are
entering information on a different row. Example: A-Y has a sum and line Z
is your total. if you are to enter from A to Y then you will have to start
over and over again. Consider entering your new information on line 2, row
A, this will still include your line A.
--
LRC


"LinZ" wrote:

I am trying to find a way to move a formula down one row if information gets
entered into column A of the same row. Does anyone know how to do that? I am
trying to calculate the total of one column as we enter new information, but
don't want to keep entering the formula every time I enter a new row of
information. Any help we be greatly appreciated! Thanks!