Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2011-04-25
Medium Priority
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
  • 2
LVL 50

Accepted Solution

Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 35463425

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

ID: 35463439
This worked perfectly, thank you!
LVL 50
ID: 35463452
Here's a screenshot.


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

564 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