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

L

LinZ

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!
 
L

LRC

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel Help to copy information from one row at a time to another sheet 1
Numbering data as entered 7
formula for moving information from one sheet to another sheet 5
Formulas in a column 3
Auto Fill formula when inserting a new line 4
Formula Assistance 7
Creating a formula to highlight a row of cells 3

Top