Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula to Sum a definable range of workbooks
I have created a workbook that collects daily data on 31 worksheets (1 per
day) and I am now trying to create a summary sheet at the end. I am trying to create a formula that will allow a user to enter a start date and end date which will provide a sum of all the work completed between the given range. Somthing along the lines of : sum ('$A$1:$B$1'!C1) Where $A$1 and $B$1 refer to two cells which contain the name of the first and last worksheet in the range (the worksheets are called '1','2','3'...'31') and C1 is the cell to be calculated. Thanks in advance for your help. Matt Chattaway |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions | |||
how can i merge 2 workbooks using a formula? | Excel Worksheet Functions |