LinkBack URL
About LinkBacks
I have attached a short copy of my spreadsheet. I have a row of dates, all mixed up, and a row of points. I want to add all the points for the same date.
I have attached a short copy of my spreadsheet. I have a row of dates, all mixed up, and a row of points. I want to add all the points for the same date.
try pivot tables..
see attached
Read here too
www.cpearson.com/excel/pivots.htm
Also, isnt this similar to your last thread for which you have provided no feedback yet?
http://www.excelforum.com/excel-form...html?p=3049838
Last edited by Ace_XL; 12-17-2012 at 02:57 PM.
Life's a spreadsheet, Excel!
Say thanks, Click *
Use a Pivot Table. Brief video demo with your data: http://screencast.com/t/dI1HFMMcS3
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks