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?

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))



"carinco" wrote:

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?

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

"carinco" wrote in message
...
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?

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

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

--
Biff
Microsoft Excel MVP


"carinco" wrote in message
...
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?

Hi Mike,

Avogadro number?

What did you do before you got into Excel?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Mike H" wrote:

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))



"carinco" wrote:

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?

Put the balance on top (?)


"carinco" skrev i melding
...
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?

I'm a chemist

"Shane Devenshire" wrote:

Hi Mike,

Avogadro number?

What did you do before you got into Excel?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Mike H" wrote:

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))



"carinco" wrote:

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?