Right well basically im a bit stuck, what i want to do is calculate the total number of goals scored for and conceded for each team. So basically i need a forumla that finds the team name in a column and counts the number cell next to it (or 3 along from it) and accumulates to a total. Is this possible? i simply cannot work out a formula to do so, any help appreciated. Thanks.
\1
Bookmarks