I am organising a world cup themed tournament. So far i have worked out different lookup formula to work out goals scored, conceded, points obtained. So when new scores are entered it automatically updates the table. I have a macro that will automatically sort the tables in the correct order as well.
My question is how to work out games played with a formula?
Trying to do a countif or sum product with 2 conditions. Namely the name of the team has a score by it indicating it has played one game, any clues anyone??
My question is how to work out games played with a formula?
Trying to do a countif or sum product with 2 conditions. Namely the name of the team has a score by it indicating it has played one game, any clues anyone??
