Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to get a cell on a page to equal the bottom most cell on dif
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 |
#2
|
|||
|
|||
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 "Learning Assisstant in need of help" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Page field link to cell | Excel Worksheet Functions | |||
need to reducing pages....i need to put the bottom part of a page. | Excel Discussion (Misc queries) | |||
How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Turn cell red if today is greater or equal to date in cell | New Users to Excel |