Excell formula to find the sum of all cells in column X from a vlookup in column y?

Hi guys,

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.
AC
defectaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dan CraciunIT ConsultantCommented:
You don't need a VLOOKUP, just some SUMIF. See attachment.

HTH,
Dan
test1.xlsx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SteveCost AccountantCommented:
For what you want to do I would suggest a PIVOTTABLE.

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...
http://www.experts-exchange.com/VP_1.html
Go to course progress, pivottables for the relevant PivotTable stuff.
RobOwner (Aidellio)Commented:
(no points) Pivot table is definitely the way to go.. I was going to suggest an array formula if you're just looking at one user but a pivot would show you everyone as well as giving you the ability to

if one of the user's is say "john" then you're array formula would be
assuming Col A is username and Col B is the number of print jobs

=SUM(IF(A1:A2000="john",B1:B2000,0))

but you need to press CTRL + SHIFT + ENTER after to finish entering the formula

if you've done that right you'll see curly braces

{=SUM(IF(A1:A2000="john",B1:B2000,0))}
Get Blueprints for Increased Customer Retention

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

SteveCost AccountantCommented:
Rob, ditch the array formula in Excel 2010 for SUMIFS or simply SUMIF for all versions... no benifit from an array formula there.

=SUMIF(A1:A2000,"john",B1:B2000)

=SUMIFS(B1:B2000, A1:A2000,"john")
RobOwner (Aidellio)Commented:
Good point Steve, thanks for the heads up :)
Dan CraciunIT ConsultantCommented:
And so we get back to my initial solution... :)
defectaAuthor Commented:
Thanks DanCraciun and everyone else for their valuble input.

I was making a simple task a lot harded than It needed to be because of a lack of knowledge of what Excel can do. Thanks again for the simple and clear answer and explanation.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.