Excel: Help me I'm going CRAZY!!! COUNTIF AND INDIRECT FORMULA?!


So basically I am creating a database of football statistics to include corners, goals, possession etc. I am concentrating on many leagues around the world and for each team I am doing a seperate tab, so there will be many tabs. For each team in the premier league for example, each tab is known as PL1, PL2, PL3 etc. I need the same formula on a statistics tab for each of the teams. Arsenal for example are known this season as PL1. For a formula to count how many games they have won I have this formula: =COUNTIF('PL1'!$T$9:$T$28,"WIN") When I drag down to the new cell, I need the PL1 to change to the next tab which will be PL2. I have tried so many different formulas and I just can't seem to get it right. Someone out there must know the answer! Thanks a million! Danfranco.


This question generated 18 answers. To proceed to the answers, click here.

This thread is current as of September 01, 2014.


For more resources for Microsoft Excel