Software

Quickly sum values in Excel without sorting

Would you like to find quick totals and counts of your data in Excel without having to sort it first? How about comparing them afterward? Mary Ann Richardson shows us a simple route in Excel to quickly adding up values without sorting.

Would you like to find quick totals and counts of your Excel data without having to sort it first? For example, suppose you have a worksheet that lists the donations to your organization by date over the past year. Each record contains the donation date, along with the amount donated and the name and address of the donor. Your donors come from five cities.

To evaluate your marketing efforts, you would like to compare the total donations for the year from donors living in each city. You could first sort the table by city and use data subtotals, or you could find the answers by entering one simple formula for each city.

To find the total number of donations from donors who live in Mt. Laurel, NJ, follow these steps:

  1. Select the column that contains the City data.
  2. Click the Name box in the Formatting toolbar, and enter City.
  3. Select the column that contains the Donation data.
  4. Click the Name box in the Formatting toolbar, and enter Donation.
  5. Enter the following formula in a cell outside the list:
    =SUMIF(City,"Mt. Laurel",Donation)
  6. Press Enter.

Excel will total the amount of donations contributed during the past year from donors living in Mt Laurel. To compare the cities, enter one formula for each of the other four cities.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

0 comments

Editor's Picks