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...
Bookmarks