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 formulae along the lines of
but I cannot get the condition to work.
What is the correct way to write this contains condition?
Is there also specific a grammar for the condition language? I've been unable to find anything.