+ Reply to Thread
Results 1 to 5 of 5

Need a countif function that takes two conditions into account PLEASE HELP URGENT

  1. #1
    Registered User
    Join Date
    01-05-2013
    Location
    London
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    2

    Need a countif function that takes two conditions into account PLEASE HELP URGENT

    Hello
    I will start by saying I am awful with excel but learn fast and I'm a psychology student, this is data from an experimental game.

    In column I is every single click made on a console, either "1" (for left) or a "3" (for a right). There are thousands and thousands of 1's and 3's in column I.

    In Column K is the clicker id e.g. "10_263C34".

    Each clicker id represents a person.

    I want to find out how many 1's and how many 3's each person (i.e. each clicker id in column K) clicked.

    Therefore I need something like "countif(I2:I432394243, "1" AND (corresponding row in K="10_263C34")"

    "countif(I2:I432394243, "3" AND (corresponding row in K="10_263C34")"

    There may also be a completely different formula to do this
    Or it may be impossible
    Thank you in advance
    Imogen

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: Need a countif function that takes two conditions into account PLEASE HELP URGENT

    hmmm as its for mac im not 100% but wouldnt countifs do your task


    somthing like

    Please Login or Register  to view this content.
    Last edited by twiggywales; 01-05-2013 at 09:46 AM.
    The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
    <--- If a post helps hit the star

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Need a countif function that takes two conditions into account PLEASE HELP URGENT

    Quote Originally Posted by imogen View Post
    Therefore I need something like "countif(I2:I432394243, "1" AND (corresponding row in K="10_263C34")"

    "countif(I2:I432394243, "3" AND (corresponding row in K="10_263C34")"
    Wow! How many rows does a Mac Excel worksheet have? Your "pseudo" formulas reference 432,394,243 rows!

    Maybe something like this:

    =COUNTIFS(I:I,1,K:K,"10_263C34")

    Better to use cells to hold the criteria:

    A1 = 1
    B1 = 10_263C34

    =COUNTIFS(I:I,A1,K:K,B1)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    01-05-2013
    Location
    London
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    2

    Re: Need a countif function that takes two conditions into account PLEASE HELP URGENT

    Thank you so much Tony Valko, that worked!!!!! Do you know how I can collapse the list of clicker id's into one where all the clicker ids are only said once rather than 100s of times?

  5. #5
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Need a countif function that takes two conditions into account PLEASE HELP URGENT

    Sounds like you want to extract the unique items.

    I have no experience with a Mac, maybe this is what you want:

    http://contextures.com/xladvfilter01.html#FilterUR

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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