Results 1 to 5 of 5

Count Formula, Based on Condition of Two other Cells

Threaded View

  1. #1
    Registered User
    Join Date
    11-20-2011
    Location
    Birmingham, UK
    MS-Off Ver
    Excel 2007
    Posts
    48

    Count Formula, Based on Condition of Two other Cells

    Good Morning All,

    The question I'm asking is to help me out with an analyses on some statistics I have on my hobby, football.

    I have a table that contains a teams playing formation e.g. 4-4-2, the score between the teams e.g. 2-0, whether the score resulted in a Win (W), Draw (D) or Loss (L) and I'm looking to count the number of Wins, Draws and Losses by the formation that they played.

    I am using Excel 2007 and have attached a sample spreadsheet with comment boxes to describe my objectives.

    Thank you in anticipation of your assistance.

    Regards,
    Colin
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula Needed to count a range of cells based on criteria in 2 other cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-01-2013, 04:06 PM
  2. [SOLVED] Formula to count number of blank cells for a specific condition in another column
    By Daniel_12 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-30-2013, 07:16 AM
  3. Replies: 8
    Last Post: 07-13-2012, 09:02 AM
  4. Replies: 2
    Last Post: 06-20-2012, 09:31 AM
  5. Replies: 3
    Last Post: 02-07-2008, 08:12 PM

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