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.

Read the forumrules, especialy the ones about crossposting.

http://www.mrexcel.com/forum/excel-q...t-formula.html

Are they classed as the same website?

No, and that is why it is called crossposting.

So why does it matter that I posted this on another website under another account?

First, because the forumrules are for every member on the forum, so also for you.

Second, more important, see the link below.


http://www.excelguru.ca/content.php?184

Your thread title was inappropriate and you crossposted...two no-nos in a single thread.

When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.

(link above in the menu bar)

Try this ..
No need of helper columns

Formula:

=COUNTIF(INDIRECT("'PL"&Row($A1)&"'!$T$9:$T$28"),"WIN")

Drag Down...