Results 1 to 6 of 6

Excel 2007 : Sum Data by Date

Threaded View

  1. #1
    Registered User
    Join Date
    08-20-2010
    Location
    Charleston, SC
    MS-Off Ver
    2007
    Posts
    3

    Smile Sum Data by Date

    I have a simple 2 column sheet that I want to total by date. The difficulty that I have it that the date includes time.

    Date/Time | Count
    8/19/2010 06:22 | 3
    8/19/2010 07:33 | 8
    8/19/2010 08:44 | 4
    8/20/2010 06:22 | 7
    8/20/2010 07:33 | 9
    8/20/2010 08:44 | 3

    My sheet has over 3000 records and do not want to manual calculate as I know there is an easier way, but cannot figure it out. What I need to do is to total up the count for each day like...

    8/19/2010 | 15
    8/20/2010 | 19

    I'm sure this is simple to someone.

    Brian

    ADD:
    After submitting my question, I thought that eventually I would want to also sum total by month so I might as well ask now.

    Example:

    January | 89
    February | 112
    March | 72
    etc...
    Last edited by brian1968; 08-21-2010 at 07:56 AM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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