I have a csv file contains a log of all the print jobs in chronological order.
each row has the user name and the total number of pages printed.
I want to add a column that has the sum total of all the print jobs for that user.
I'm thinking if I could sum all the cells in column X from a vlookup of all the cells in column Y this would get me the result I want, would it not?
I just have no idea how to write it or if those formulas are the right way to go about it. Any suggestions?
I am using Office 2010
Thanks in advance.
This will be more useful as it can be sorted alphabetically, grouped by dates, etc etc.
To add a pivot table, select a cell in your data, choose the INSERT tab and The first icon should be PIVOTTABLE.
There are many guides on Pivot Tables on the web such as this...
Go to course progress, pivottables for the relevant PivotTable stuff.