Solved

How to sum cells with two criteria each from different columns?

Posted on 2014-12-30
1
75 Views
Last Modified: 2014-12-31
I have three columns.  The 1st and 3rd have text.  The 2nd has integers.
For example   |  Name  |    39  |   City  |
I need to add all the second columns that have a certain Name and a certain City.  If both values match, then add the number in column 2.

Any help?
0
Comment
Question by:the_hero
1 Comment
 
LVL 50

Accepted Solution

by:
teylyn earned 500 total points
Comment Utility
Hello,

Sumifs() will do what you need. Consider this:

shot
The formula in cell E2 sums all values where the Name is "Ben" and the City is "Rome"

=SUMIFS(B2:B7,A2:A7,"Ben",C2:C7,"Rome")

Adjust ranges to your requirements.

cheers, teylyn
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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;…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

762 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

12 Experts available now in Live!

Get 1:1 Help Now