Results 1 to 23 of 23

Countif with same criteria in multiple columns

Threaded View

  1. #1
    Registered User
    Join Date
    08-20-2015
    Location
    London
    MS-Off Ver
    365 version 2302
    Posts
    22

    Countif with same criteria in multiple columns

    So I've got a spreadsheet for my football team which shows stats for the players over the season. I've recently started noting what positions people play, and I want to be able to filter the stats by the position. The challenge is that some people play multiple positions over the course of a match, so I've ended up with several columns for the position played.

    The below picture is some test data which I've simplified. As you can see, if I put "Primary" and "LB, it correctly pulls 6 matches for Alex and 0 for Tim. What I want is to be able to put "Any" and "LM" and it to return the 3 matches which Alex played at LM. I found a previous thread where Sum and Mmult were used but I couldn't figure out how to get something like that to work with my data. I've attached the original sheet for reference.
    sample.PNG
    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. Countif using criteria in multiple columns
    By vesterholt in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-10-2014, 03:20 PM
  2. CountIf Multiple criteria and columns
    By extko1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-05-2013, 12:35 PM
  3. COUNTIF with multiple criteria and columns
    By burtonlang in forum Excel General
    Replies: 2
    Last Post: 04-10-2013, 05:43 AM
  4. [SOLVED] trying to do a "countif" with multiple ranges and multiple criteria. Countif, Sumproduct?
    By completelyhis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2013, 06:12 PM
  5. [SOLVED] COUNTIF with multiple criteria on several columns (different column heading)
    By rose4emi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-20-2012, 06:41 AM
  6. Countif with criteria in multiple columns
    By syoung236 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-03-2012, 05:10 PM
  7. Replies: 8
    Last Post: 02-10-2009, 08:56 AM
  8. Countif - Two Criteria in two columns are met.
    By samprince in forum Excel General
    Replies: 12
    Last Post: 06-28-2006, 11:58 AM

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