league table

J

Jim

I have a league table set up to calculate the results, I have the teams and
the scores on the left side of the spreadsheet and the league table beside
it. I want to be able to use an if function, I think, to be able to
calculate the league table from the scores on the left, i.e.

Results League table
name 2 1 name Name – played - won –lost – draw – for – agst – total - Pts
name 3 1 name

If the team name in the league table is the same as the result how do I
create a formula that will add the points and scores etc to the corresponding
name on the league table. I have tried a number of formulas but cant get it
to work, hope this makes sense to someone and thanks in anticipation
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

basketball scoring 0
Creating a League table 0
Only Calculating Numerics 5
League table 3
Access SoccerTemplate 0
pool league table setup 0
SumIF or CountIF 4
League Table Help 6

Top