Excell formula to find the sum of all cells in column X from a vlookup in column y?
Posted on 2014-01-08
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.