formula to lookup last entry in a list?

**Baldy1** · 10-20-2008, 02:50 PM

I have a list of account balances in one column. How can I pick up only the bottom number in that column? I have 20 worksheets and want a total across all worksheets of the last number listed in a particular column but each worksheet is different because they contain a different number of rows with activity. So, if in col. C I have:

$482
$1,000
$899
$456
$231

... then I want $231 to be what is captured for that worksheet, but if the 2nd worksheet contains:

$500
$1000
$344

... then I want $344 to be what is captured for worksheet 2. Does that make sense. In the end I want to sum $231, $344.... etc.

Thanks if you can help.

**NBVC** · 10-20-2008, 02:52 PM

To get last number in column C of any worksheet...try:

=Lookup(9.99999999e+307,C:C)

Put that result in the same cell of each sheet, then you can use sum across the sheets..

e.g. =Sum(Sheet1:Sheet10!X1)

Where you have Sheets 1 to 10 summing X1 in each sheet.