Enter only last values in a list

[mittmje]

Need way of entering only the last value (new values added to the list periodically) in a list:

Spreadsheet 1 contains 2 lists of say 50 entries like the following:
50 100
54 110
56 112
52 101
60 125

Spreadsheet 2 should enter:
Sum of last 2 horizontal values entered in spreadsheet 1 list (i.e.: 60+125=185)

Ignore any blank rows


Thank You

[sweep]

Hi,

Assuming your lists are in columns A and B, and occupy less than 100 rows, this should do it for you.

Please Login or Register  to view this content.

[mittmje]

Thank you
Do I put Spreadsheet 1 before INDEX?

[sweep]

So I guess you want the result on a seperate sheet to the data?

In that case you'll need the sheet name before every range, like this..

Please Login or Register  to view this content.

[Zer0Cool]

Need way of entering only the last value (new values added to the list periodically) in a list:

Spreadsheet 1 contains 2 lists of say 50 entries like the following:
50 100
54 110
56 112
52 101
60 125

Are your values always in descending order as in your example? If so this could be done using:

Please Login or Register  to view this content.

[mittmje]

Fantastic, works great
Thanks