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!