+ Reply to Thread
Results 1 to 2 of 2

Sum'ing groups of data

Hybrid View

  1. #1
    Registered User
    Join Date
    12-09-2009
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    68

    Sum'ing groups of data

    Hey All,
    I have a list of dates with data next to it. I need to figure out a way to get the sum of every 7 dates as a line item.
    For example: I need it from Tuesday to Tuesday and then a line item with the total next to it.

    Tuesday, February 17, 2009
    Wednesday, February 18, 2009
    Thursday, February 19, 2009
    Friday, February 20, 2009
    Saturday, February 21, 2009
    Sunday, February 22, 2009
    Monday, February 23, 2009
    Tuesday, February 24, 2009

    Wednesday, February 25, 2009
    Thursday, February 26, 2009

    Anyone have a thought on this?
    Attached Files Attached Files
    Last edited by afriedman; 07-12-2011 at 05:17 PM.

  2. #2
    Registered User
    Join Date
    12-09-2009
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    68

    Re: Sum'ing groups of data

    Never mind - I figured out an easy solution.
    Just sum the first 7 paste it in the next column. Do it one more time, and then from the top drag down and whalla!

    See attached spreadsheet for reference...

    Thanks anyway!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1