I want a cell to show total from other cell when that cell changes

[carinco]

I have a simple spreadsheet that shows a balance in one column. However after
each input the balance total moves down to the next row. I want to see the
balance total in another worksheet. How can I acheive this when the total
keeps moving down a row?

 

[Mike H]

Hi,

I'm not sure I understand but this will return the last numeric value in
column B of sheet 1.

=INDEX(Sheet1!B:B,MATCH(6.022*10^23,Sheet1!B:B))

 

[Ashish Mathur]

Hi,

On worksheet 1, highlight the range (including the heading row) [say
B12:B55] which you would like to sum up and press Ctrl + L (for converting
the range to a list). Now on worksheet 2, enter the sum formula =sum(range
on sheet1). Now whenever, you add data to the range in sheet , it will
automatically get included in the SUM function on worksheet 2.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[T. Valko]

This will return the *last* numeric value from Sheet1 coulmn A:

=LOOKUP(1E100,Sheet1!A:A)

 

[Shane Devenshire]

Hi Mike,

Avogadro number?

What did you do before you got into Excel?

 

[DS-NTE]

Put the balance on top (?)

 

[Mike H]

I'm a chemist

Hi Mike,

Avogadro number?

What did you do before you got into Excel?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire