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.