how to get a cell on a page to equal the bottom most cell on dif

  • Thread starter Learning Assisstant in need of help
  • Start date
L

Learning Assisstant in need of help

I am trying to make a excell spreadsheet with a summary page referring back
to a list on a different page in the same worksheet. I need the daily number
on teh summary page to equal either the bottom most filled in row in a
column, or the top most row in a column, whichever is easier to do. Also, is
there any way to add the bottom or topmost 7 numbers and put that total in a
different cell
 
P

Peo Sjoblom

If indeed they are all filled without blanks in-between you can use

=INDEX($B$1:$B$10000,COUNT($B$1:$B$1000))

to sum the 7 largest numbers


=SUMPRODUCT(LARGE($B$1:$B$20000,ROW(INDIRECT("1:7"))))

for the opposite use SMALL instead of LARGE

Regards,

Peo Sjoblom
 
Top