Author Topic: New Excel question  (Read 3027 times)

  • Offline zpyder

  • Posts: 6,946
  • Hero Member
New Excel question
on: April 21, 2014, 21:33:59 PM
I've got a large spreadsheet/CSV.

It contains several columns, first one is date, containing a separate row for each day of the year from 2009 to present. The other columns are things like downloads, earnings etc.

I'm wanting to find a way of summarising this data so that I can see by month total downloads and earnings.

Not entirely sure where to begin, thought vlookup might be the badger, but I had 2 hours sleep before getting up at 4AM today so my brain is fried! It seems more hassle than it's worth, when I could just copy and paste monthly summaries. Just thought I should try and do things "the proper" way.

Re: New Excel question
Reply #1 on: April 22, 2014, 09:04:47 AM
Two ways, add another 2 columns to display only month and year then use a pivot or something like this:

http://www.mrexcel.com/forum/excel-questions/631125-sum-data-month-year.html

0 Members and 1 Guest are viewing this topic.