How do I add similar rows in Excel 2010 without manually having to use SUMIF & specific criteria?

Posted on 2011-04-25
Last Modified: 2012-05-11
I have an Excel document that has two columns, vendor & payment amount. I have a long list of vendors and associated payments, but I need to generate a total, by vendor. That is, find all the like vendors and total it. I know I could use SUMIF but would need to specify each vendor manually, which would be impractical as the list is too long.

 Want to automate to sum & consolidate columns A/B to D/E
Question by:jalant
    LVL 50

    Accepted Solution


    click a cell in Column A or B, within your data set, then click Insert > Pivot table. Either choose to put it on a new sheet or click a cell on the existing sheet. Drag the Vendor field to the row area and the amount to the Values area and make sure to set it to Sum. Now you've successfully created a pivot table.

    cheers, teylyn

    Author Closing Comment

    This worked perfectly, thank you!
    LVL 50

    Expert Comment

    Here's a screenshot.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now