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

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?
LVL 1
Shaye LarsenAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.