View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default How do I SUM several worksheet to a final worksheet?

=SUM(Jan:Feb!H1)

should do it, change to your names and cell.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Michael Q" <Michael wrote in message
...
Have created a worksheet that has tabs for each month of the year

(beginning
with the second tab). On column H of each worksheet is a TOTAL column of
money given for that month. I have a fourteenth tab that is titled Year

to
Date. How do I create a formula that will compute each month's giving to
that Year to Date worksheet so I can keep track of an individuals Year to
Date giving at any given time?