View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HL HL is offline
external usenet poster
 
Posts: 8
Default Summing across multiple worksheets

I have the worksheets with the following column headings:
Name Acct1 Acct2 Acct3

The rows are listed for each week:
1/6/08
1/13/08
1/20/08
1/27/08

The entries are as follows:
1/6/08 John Doe $20 $100 $0
1/20/08 John Doe $0 $200 $0
1/27/08 John Doe $50 $0 $0

I have multiple worksheets (e.g. January - December) with this setup.
I need help summing the yearly totals for each person. That is to say, I
need John Doe's summation for January thru December however i don't know how
to do this.

Help please!!