Results 1 to 13 of 13

Countif and indirect formula

Threaded View

  1. #1
    Registered User
    Join Date
    09-01-2014
    Location
    England
    MS-Off Ver
    2013
    Posts
    6

    Question 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.
    Last edited by JBeaucaire; 09-01-2014 at 07:47 PM. Reason: Corrected Thread Title.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Adding Indirect formula to a Countif
    By nikkilynn2 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-03-2014, 08:24 PM
  2. [SOLVED] 2 data Range using COUNTIF with INDIRECT and MIN IF with INDIRECT,
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-29-2013, 08:10 PM
  3. [SOLVED] Countif function goes crazy
    By ANS in forum Excel Formulas & Functions
    Replies: 29
    Last Post: 08-04-2013, 04:55 AM
  4. Help I am going crazy with this formula.
    By laz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-10-2005, 06:22 PM
  5. Crazy formula
    By swmasson in forum Excel General
    Replies: 8
    Last Post: 03-04-2005, 05:04 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1