Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
3-D Reference
at the beginning of the day sheets put in a blank sheet named start. At the
end of the day sheets, put in a blank sheet named End. =If(Sum('Start:End'!B2)=0,0,Average('Start:End'!B2 )) Each month put you daily sheets between start and end. -- Regards, Tom Ogilvy Carrie wrote in message ... Hello, Does anyone know the syntax for inserting a 3-D formula into a cell? I have a workbook with sheets for each day of the month. On a separate (new) sheet, I would like to calculate averages for the month. The formula I want is: =IF(SUM('01-Jan:31-Jan'!B2)=0, 0, AVERAGE('01-Jan:31-Jan'!B2)) How would I transorm "'01-Jan:31-Jan'!" into generic code using a text string? Is there a way to just select all the sheets in a workbook and then specifiy the cell? Or do I have to construct a string to specify the range? Any help would be greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
Row reference increment but preserve column reference | Excel Worksheet Functions |