Hello, I need to sum up numbers in one column based on multiple criterion in another column as well as one criteria in one more column. Example below: Criteria 1 Criteria 2 Numbers Green Round 5 Green Square 2 Red Round 1 In this case, I would be interested in summing up all numbers that are BOTH square and round as well as green. How do I go about making this operation in Excel? Thank you.
Solved by T. Y. in 25 mins