Is there a way to automatically change the location of a formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a spreadsheet for my supervisor. He wants the program to be
able to calculate the total right below the amount of items he enters.
However, he may enter 1 item or 25. Is there some way to do this?
 
If there is nothing else in column A, then in any cell in B use =SUM(A:A)
 
I know how to use the sum function, but I don't think I am presenting the
question properly. He wants to enter anywhere from 2 items to 30 in column
B. But, he wants the total to appear directly below the items, whether it's
2 or 30. But, he doesn't want to have to insert or delete cells. I was
wondering if there was some kind of floating formula.
 
You must log in or register to reply here.

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

Overwriting a cell with a formula without deleting the formula 1
FORMULA TO ADD ROW 2
Tiered Pricing Formulae - is this possible? 3
insert two formulas one cell 1
How to prevent each item date from changing after "TODAY" formula 2
Trying to change a cell formula 2
Financial Time Value of Money calculations 5
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2

Back
Top