| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing values from an undetermined number of sheet
Is there a smart way to sum numbers not knowing the last sheet i should
consider in the sum? Thanks, Stefano |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing values from an undetermined number of sheet
Create a Start sheet and an End sheet
=SUM(Start:End!A1) "smaruzzi" wrote: Is there a smart way to sum numbers not knowing the last sheet i should consider in the sum? Thanks, Stefano |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing values from an undetermined number of sheet
Thnaks, for the suggestion, but I'd like to understand if i can create a
dynamic formula where the last sheet to be considered is calculated programmatically. I explored INDIRECT() but apparently it doesn't work with aggregate functions. Any workaround? Thanls, Stefano "Teethless mama" wrote: Create a Start sheet and an End sheet =SUM(Start:End!A1) "smaruzzi" wrote: Is there a smart way to sum numbers not knowing the last sheet i should consider in the sum? Thanks, Stefano |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing values from an undetermined number of sheet
You cannot use a dynamic formula when it comes to sheets and future sheets.
Best way is to use dummy sheets and always add future sheets in-between the dummy sheets described in the answer you received -- Regards, Peo Sjoblom "smaruzzi" wrote in message ... Thnaks, for the suggestion, but I'd like to understand if i can create a dynamic formula where the last sheet to be considered is calculated programmatically. I explored INDIRECT() but apparently it doesn't work with aggregate functions. Any workaround? Thanls, Stefano "Teethless mama" wrote: Create a Start sheet and an End sheet =SUM(Start:End!A1) "smaruzzi" wrote: Is there a smart way to sum numbers not knowing the last sheet i should consider in the sum? Thanks, Stefano |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste Values in Number of rows as count in other sheet | Excel Discussion (Misc queries) | |||
| summing values in one row based on values in another row | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
| searching for values and summing the corresponding values | Excel Worksheet Functions | |||
Linear Mode
