Shaye Larsen
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.