+ Reply to Thread
Results 1 to 3 of 3

Multiple Criteria with Countif Statements

  1. Multiple Criteria with Countif Statements

    My question to use, is how do I use a similar formula when dealing
    with text in all cells? For instance, how can I write a countif
    statement that will return all the "Profile" in column D that also
    have "Monster.com" in column C?


    A B C D

    Last Name First Name Source Status
    Patel Mainakini Monster.com Profile
    Seres Amy CollegeCentral.com Interview

  2. Re: Multiple Criteria with Countif Statements

    =sumproduct(--(c1:c1000="monster.com"),--(d1:d1000="profile))

    is one way.

    Sumproduct likes to see numbers. The double minus signs change trues/falses to
    1's and 0's.

    Gaeton Biscardi wrote:
    >
    > My question to use, is how do I use a similar formula when dealing
    > with text in all cells? For instance, how can I write a countif
    > statement that will return all the "Profile" in column D that also
    > have "Monster.com" in column C?
    >
    >
    > A B C D
    >
    > Last Name First Name Source Status
    > Patel Mainakini Monster.com Profile
    > Seres Amy CollegeCentral.com Interview


    --

    Dave Peterson
    ec35720@msn.com

  3. Re: Multiple Criteria with Countif Statements

    Hello,

    or this way:
    =sumproduct((C1:C1000="monster.com")*(D11000="profile"))

    Regards
    Beate


    Dave Peterson wrote in message news:<4148E68D.53FD5614@msn.com>...
    > =sumproduct(--(c1:c1000="monster.com"),--(d1:d1000="profile))
    >
    > is one way.
    >
    > Sumproduct likes to see numbers. The double minus signs change trues/falses to
    > 1's and 0's.
    >
    > Gaeton Biscardi wrote:
    > >
    > > My question to use, is how do I use a similar formula when dealing
    > > with text in all cells? For instance, how can I write a countif
    > > statement that will return all the "Profile" in column D that also
    > > have "Monster.com" in column C?
    > >
    > >
    > > A B C D
    > >
    > > Last Name First Name Source Status
    > > Patel Mainakini Monster.com Profile
    > > Seres Amy CollegeCentral.com Interview


+ Reply to Thread