Hello everyone!
I'm a newcomer here in this forum, so I'd like to apologize in advance for any of my mistakes.
I'm not really good with excel formulas, so it would be super cool if I could get an assistance on solving this problem that I'm facing right now.
So here's the deal:
I have this data of Indonesian Super League 2011-12 results, as shown on the example below.
example.JPG
I'm trying to count how many times the home team Persipura won a match.
Using manual 'eyeballing' method, on that example, with Persipura played twice at home, they won 1 match (row 10, Persipura 3-1 Gresik United), and drew 1 match (row 2, Persipura 3-3 Persiba). So the correct answer is 1.
But how am I going to count the equation using excel formula?
Thank you in advance for your kind response.
Regards,
Pramuaji "Ajay"
Bookmarks