SUM condition on one set of columns where another includes certain values
- by pjp
I have the following data in Excel where I want a formula that will give me the sum of all of the total rows:
A B
australia 10
australia total 10
china 1
china 5
china 7
china total 13
I have tried…