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!
|