Unaffiliated and back on new, improved hosting
April 27, 2024, 20:51:48 PM
Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Tekforums.net
- The
improved
home of Tekforums!
News:
Home
Help
Search
Login
Register
Tekforums
»
Chat
»
Entertainment & Technology
(Moderator:
Mardoni
) »
New Excel question
« previous
next »
Print
Pages: [
1
]
Author
Topic: New Excel question (Read 3027 times)
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.
Logged
XEntity
Posts: 2,678
Hero Member
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
Logged
Print
Pages: [
1
]
« previous
next »
0 Members and 1 Guest are viewing this topic.
Tekforums
»
Chat
»
Entertainment & Technology
(Moderator:
Mardoni
) »
New Excel question