A MrExcel virgin hopes someone can help...
How can I create a SUMIF function with two conditions, reading from two different columns?
For example, I have a list of records that include columns for location, revenue and business line. I want to sum revenue for each business line in each location.
How can I create a SUMIF function with two conditions, reading from two different columns?
For example, I have a list of records that include columns for location, revenue and business line. I want to sum revenue for each business line in each location.