Solved

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

Posted on 2014-12-30
1
79 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:Shaye Larsen
1 Comment
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 40525001
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

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

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

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Outlook Free & Paid Tools
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 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