Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Florida
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sorry, but I can't figure this out.

    I have a simple Excel 2007 worksheet for tracking individual giving for a church that tracks various categories and gives a weekly total for each name. I rename a master sheet each week to get a blank copy for making the current week's entries.

    Is it possible to have a field that will give a running yearly total without having 52 separate fields for each row?

    Thank you.

    Paul

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Short answer would be probably.

    Longer answer would be the solution but without a sample of your workbook that's near impossible. Please upload a sample.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Instead of creating a new sheet for each week, I'd create a single data table for the entire year.

    You can then use a pivot table to group the data by individual and by week, with a running total.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •