How about

=INDIRECT("Jan:"&TEXT(TODAY(),"mmm")&"!D4")

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
Here's my Problem:
I have monthly sheets that keep tabs of production time for various
colors of widgets. I have 12 sheets one for each month. Each Identical
to the other.
I have an EOY (End of Year) sheet, also identical which I want to use
not only for EOY but also to check how we are doing YTD.

Keeping tabs on columns of widgets is easy summing thru the cells on
each workesheet =sum(Jan:Dec!d4). However getting the running clock
total is not as easy. I don't want to do =average() because that would
be averageing averages. I can get at the # I want by putting the month
out on a flat linear sheet and using
(b3*c3)+(d3*e3)+(f3*)+etc.../Total widgets. In this example the B3
would be # of widgets and c3 would be time say for january, and so
on...

How can I do this on the EOY sheet without writing a massive formula.
I hope this is clear