| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=SUM(Sheet2:Sheet9!IV65536)-meaning of equation?
I am trying to add the value of the last cell in the last column across
several worksheets. Can anyone explain what I can look up to learn this? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=SUM(Sheet2:Sheet9!IV65536)-meaning of equation?
This will add the value in IV66636 for worksheets Sheet2 to Sheet9 inclusive.
HTH "djc" wrote: I am trying to add the value of the last cell in the last column across several worksheets. Can anyone explain what I can look up to learn this? Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=SUM(Sheet2:Sheet9!IV65536)-meaning of equation?
My guess is that you have to use a formula on each sheet that will find the
last cell =LOOKUP(9.99999999999999E+307,IV:IV) will return what's in the last cell if numeric, then if you link to that on each sheet in let's say A1 SO A1 holds that formula then you can use =SUM(Sheet1:Sheet9!A1) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "djc" wrote in message ... I am trying to add the value of the last cell in the last column across several worksheets. Can anyone explain what I can look up to learn this? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel graphed trendline does not match derived equation | Charts and Charting in Excel | |||
| Equation to refer to data value(s) and not the cell?? | Excel Discussion (Misc queries) | |||
| Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
| Need Help with #N/A in equation | Excel Discussion (Misc queries) | |||
| Averaging/Rounding Equation Problem | Excel Worksheet Functions | |||
Hybrid Mode
