Hi,
Please download the sample workbook first.
As you can see in my workbook "B9" means all the run South Africa scored against all the other teams.
and "C9" means all the other teams scored run against South Africa.
Its just a sample, so I want to create a formula for "B9" and "C9".
My english is poor thats why it is difficult for me to explain, I hope you understand.
Thanks in advance.
Bookmarks