Let's say you monthly worksheets were name jan, feb, mar,....and year was the
yearly sheet. Your formula for A1 in the year sheet would be:


=jan!A1+feb!A1+mar!A1.....
--
Gary''s Student


"Ratman" wrote:

I have a worksheet for each month and a Year total worksheet. I would like
to sum up the corresponding monthly values into the same cell on the Year
total worksheet. I seem to recall that there is a simple way to do this
but...it's been more that 10 minutes ago.