Okay, so I got a workbook with three columns- Billing ID, charge, and Date. Right now I need to find out how to, say, pull all of the #1's under Billing ID and sum their respective Charge prices. then I will need to sort those by date. Does anyone here know how to do this?
I've enclosed the workbook. Thanks in advance.
EDIT
Last edited by anakinflair; 12-08-2008 at 04:09 PM.
Looks like you already have it; select Sort Ascending for the Date column, and 1 for the Billing ID column.
Entia non sunt multiplicanda sine necessitate
Okay, so I figured out the first part. Now I just need to sort them by month, IE breaking down by January, February, etc. I should clarify that these totals will then be pulled onto a seperate spreadsheet that is still being designed. I've updated the workbook to reflect where I'll need the individual months' data to be forwarded on sheet 2. Thanks again.
How about a pivot table. I added a "month" column to help the sorting/subtotals.
I can try a pivot table, but I don't think that's what the boss wants. He just wants the charges broken down by month on sheet two.
Yeah, it needs to be a funtion, not a pivot table.
You could try just using basic data filtering. Filter the ID column to the ID you want and then sort the resulting data by date.
how would I do that?
How do I use basic data filtering? I'm just a newbie with this program.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks