+ Reply to Thread
Results 1 to 16 of 16

countif question using 2 conditions

  1. #1
    Guest

    Re: countif question using 2 conditions

    Hi Flutie

    One option is to use SUMPRODUCT. Have a look here for some examples:
    http://www.contextures.com/xlFunctio...tml#SumProduct

    Andy.

    "Flutie99" <[email protected]> wrote in message
    news:[email protected]...
    >i need to count the number of companies that are selected (using "1" or "0"
    > in one column) and have posiitve growth rates (in another column). is
    > there
    > a countif function that lets me do this?




  2. #2
    Flutie99
    Guest

    Re: countif question using 2 conditions

    Perhaps I should be more specific:

    Sheet 1 has:
    Co. A 1
    Co. B 0
    Co. C 1

    Sheet 2 has:
    Co. A -1%
    Co. B 2%
    Co. C 5%

    I need to count the number of companies with 1 and positive growth. In the
    example, the answer would be 1 since co. c is the only that meets the
    criteria.


    "Andy" wrote:

    > Hi Flutie
    >
    > One option is to use SUMPRODUCT. Have a look here for some examples:
    > http://www.contextures.com/xlFunctio...tml#SumProduct
    >
    > Andy.
    >
    > "Flutie99" <[email protected]> wrote in message
    > news:[email protected]...
    > >i need to count the number of companies that are selected (using "1" or "0"
    > > in one column) and have posiitve growth rates (in another column). is
    > > there
    > > a countif function that lets me do this?

    >
    >
    >


  3. #3
    Flutie99
    Guest

    Re: countif question using 2 conditions

    figured it out. by the way, what does "--" do?

    "Flutie99" wrote:

    > Perhaps I should be more specific:
    >
    > Sheet 1 has:
    > Co. A 1
    > Co. B 0
    > Co. C 1
    >
    > Sheet 2 has:
    > Co. A -1%
    > Co. B 2%
    > Co. C 5%
    >
    > I need to count the number of companies with 1 and positive growth. In the
    > example, the answer would be 1 since co. c is the only that meets the
    > criteria.
    >
    >
    > "Andy" wrote:
    >
    > > Hi Flutie
    > >
    > > One option is to use SUMPRODUCT. Have a look here for some examples:
    > > http://www.contextures.com/xlFunctio...tml#SumProduct
    > >
    > > Andy.
    > >
    > > "Flutie99" <[email protected]> wrote in message
    > > news:[email protected]...
    > > >i need to count the number of companies that are selected (using "1" or "0"
    > > > in one column) and have posiitve growth rates (in another column). is
    > > > there
    > > > a countif function that lets me do this?

    > >
    > >
    > >


  4. #4
    Guest

    Re: countif question using 2 conditions

    Hi

    -- coerces a TRUE or a FALSE into being a number. If you type =TRUE into a
    cell, you get TRUE. If you type =--TRUE into a cell, you get 1. It's a
    simple way of making a TRUE result equal 1 and a FALSE result equal 0 - for
    calculation purposes.

    Andy.

    "Flutie99" <[email protected]> wrote in message
    news:[email protected]...
    > figured it out. by the way, what does "--" do?
    >
    > "Flutie99" wrote:
    >
    >> Perhaps I should be more specific:
    >>
    >> Sheet 1 has:
    >> Co. A 1
    >> Co. B 0
    >> Co. C 1
    >>
    >> Sheet 2 has:
    >> Co. A -1%
    >> Co. B 2%
    >> Co. C 5%
    >>
    >> I need to count the number of companies with 1 and positive growth. In
    >> the
    >> example, the answer would be 1 since co. c is the only that meets the
    >> criteria.
    >>
    >>
    >> "Andy" wrote:
    >>
    >> > Hi Flutie
    >> >
    >> > One option is to use SUMPRODUCT. Have a look here for some examples:
    >> > http://www.contextures.com/xlFunctio...tml#SumProduct
    >> >
    >> > Andy.
    >> >
    >> > "Flutie99" <[email protected]> wrote in message
    >> > news:[email protected]...
    >> > >i need to count the number of companies that are selected (using "1"
    >> > >or "0"
    >> > > in one column) and have posiitve growth rates (in another column).
    >> > > is
    >> > > there
    >> > > a countif function that lets me do this?
    >> >
    >> >
    >> >




  5. #5
    Dave Breitenbach
    Guest

    Re: countif question using 2 conditions

    Here is a better website which descibes in more detail the use of "--"
    http://www.xldynamic.com/source/xld.SUMPRODUCT.html

    "Flutie99" wrote:

    > figured it out. by the way, what does "--" do?
    >
    > "Flutie99" wrote:
    >
    > > Perhaps I should be more specific:
    > >
    > > Sheet 1 has:
    > > Co. A 1
    > > Co. B 0
    > > Co. C 1
    > >
    > > Sheet 2 has:
    > > Co. A -1%
    > > Co. B 2%
    > > Co. C 5%
    > >
    > > I need to count the number of companies with 1 and positive growth. In the
    > > example, the answer would be 1 since co. c is the only that meets the
    > > criteria.
    > >
    > >
    > > "Andy" wrote:
    > >
    > > > Hi Flutie
    > > >
    > > > One option is to use SUMPRODUCT. Have a look here for some examples:
    > > > http://www.contextures.com/xlFunctio...tml#SumProduct
    > > >
    > > > Andy.
    > > >
    > > > "Flutie99" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > >i need to count the number of companies that are selected (using "1" or "0"
    > > > > in one column) and have posiitve growth rates (in another column). is
    > > > > there
    > > > > a countif function that lets me do this?
    > > >
    > > >
    > > >


  6. #6
    Guest

    Re: countif question using 2 conditions

    Hi Flutie

    One option is to use SUMPRODUCT. Have a look here for some examples:
    http://www.contextures.com/xlFunctio...tml#SumProduct

    Andy.

    "Flutie99" <[email protected]> wrote in message
    news:[email protected]...
    >i need to count the number of companies that are selected (using "1" or "0"
    > in one column) and have posiitve growth rates (in another column). is
    > there
    > a countif function that lets me do this?




  7. #7
    Flutie99
    Guest

    Re: countif question using 2 conditions

    Perhaps I should be more specific:

    Sheet 1 has:
    Co. A 1
    Co. B 0
    Co. C 1

    Sheet 2 has:
    Co. A -1%
    Co. B 2%
    Co. C 5%

    I need to count the number of companies with 1 and positive growth. In the
    example, the answer would be 1 since co. c is the only that meets the
    criteria.


    "Andy" wrote:

    > Hi Flutie
    >
    > One option is to use SUMPRODUCT. Have a look here for some examples:
    > http://www.contextures.com/xlFunctio...tml#SumProduct
    >
    > Andy.
    >
    > "Flutie99" <[email protected]> wrote in message
    > news:[email protected]...
    > >i need to count the number of companies that are selected (using "1" or "0"
    > > in one column) and have posiitve growth rates (in another column). is
    > > there
    > > a countif function that lets me do this?

    >
    >
    >


  8. #8
    Flutie99
    Guest

    Re: countif question using 2 conditions

    figured it out. by the way, what does "--" do?

    "Flutie99" wrote:

    > Perhaps I should be more specific:
    >
    > Sheet 1 has:
    > Co. A 1
    > Co. B 0
    > Co. C 1
    >
    > Sheet 2 has:
    > Co. A -1%
    > Co. B 2%
    > Co. C 5%
    >
    > I need to count the number of companies with 1 and positive growth. In the
    > example, the answer would be 1 since co. c is the only that meets the
    > criteria.
    >
    >
    > "Andy" wrote:
    >
    > > Hi Flutie
    > >
    > > One option is to use SUMPRODUCT. Have a look here for some examples:
    > > http://www.contextures.com/xlFunctio...tml#SumProduct
    > >
    > > Andy.
    > >
    > > "Flutie99" <[email protected]> wrote in message
    > > news:[email protected]...
    > > >i need to count the number of companies that are selected (using "1" or "0"
    > > > in one column) and have posiitve growth rates (in another column). is
    > > > there
    > > > a countif function that lets me do this?

    > >
    > >
    > >


  9. #9
    Guest

    Re: countif question using 2 conditions

    Hi

    -- coerces a TRUE or a FALSE into being a number. If you type =TRUE into a
    cell, you get TRUE. If you type =--TRUE into a cell, you get 1. It's a
    simple way of making a TRUE result equal 1 and a FALSE result equal 0 - for
    calculation purposes.

    Andy.

    "Flutie99" <[email protected]> wrote in message
    news:[email protected]...
    > figured it out. by the way, what does "--" do?
    >
    > "Flutie99" wrote:
    >
    >> Perhaps I should be more specific:
    >>
    >> Sheet 1 has:
    >> Co. A 1
    >> Co. B 0
    >> Co. C 1
    >>
    >> Sheet 2 has:
    >> Co. A -1%
    >> Co. B 2%
    >> Co. C 5%
    >>
    >> I need to count the number of companies with 1 and positive growth. In
    >> the
    >> example, the answer would be 1 since co. c is the only that meets the
    >> criteria.
    >>
    >>
    >> "Andy" wrote:
    >>
    >> > Hi Flutie
    >> >
    >> > One option is to use SUMPRODUCT. Have a look here for some examples:
    >> > http://www.contextures.com/xlFunctio...tml#SumProduct
    >> >
    >> > Andy.
    >> >
    >> > "Flutie99" <[email protected]> wrote in message
    >> > news:[email protected]...
    >> > >i need to count the number of companies that are selected (using "1"
    >> > >or "0"
    >> > > in one column) and have posiitve growth rates (in another column).
    >> > > is
    >> > > there
    >> > > a countif function that lets me do this?
    >> >
    >> >
    >> >




  10. #10
    Dave Breitenbach
    Guest

    Re: countif question using 2 conditions

    Here is a better website which descibes in more detail the use of "--"
    http://www.xldynamic.com/source/xld.SUMPRODUCT.html

    "Flutie99" wrote:

    > figured it out. by the way, what does "--" do?
    >
    > "Flutie99" wrote:
    >
    > > Perhaps I should be more specific:
    > >
    > > Sheet 1 has:
    > > Co. A 1
    > > Co. B 0
    > > Co. C 1
    > >
    > > Sheet 2 has:
    > > Co. A -1%
    > > Co. B 2%
    > > Co. C 5%
    > >
    > > I need to count the number of companies with 1 and positive growth. In the
    > > example, the answer would be 1 since co. c is the only that meets the
    > > criteria.
    > >
    > >
    > > "Andy" wrote:
    > >
    > > > Hi Flutie
    > > >
    > > > One option is to use SUMPRODUCT. Have a look here for some examples:
    > > > http://www.contextures.com/xlFunctio...tml#SumProduct
    > > >
    > > > Andy.
    > > >
    > > > "Flutie99" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > >i need to count the number of companies that are selected (using "1" or "0"
    > > > > in one column) and have posiitve growth rates (in another column). is
    > > > > there
    > > > > a countif function that lets me do this?
    > > >
    > > >
    > > >


  11. #11
    Flutie99
    Guest

    countif question using 2 conditions

    i need to count the number of companies that are selected (using "1" or "0"
    in one column) and have posiitve growth rates (in another column). is there
    a countif function that lets me do this?

  12. #12
    Guest

    Re: countif question using 2 conditions

    Hi Flutie

    One option is to use SUMPRODUCT. Have a look here for some examples:
    http://www.contextures.com/xlFunctio...tml#SumProduct

    Andy.

    "Flutie99" <[email protected]> wrote in message
    news:[email protected]...
    >i need to count the number of companies that are selected (using "1" or "0"
    > in one column) and have posiitve growth rates (in another column). is
    > there
    > a countif function that lets me do this?




  13. #13
    Flutie99
    Guest

    Re: countif question using 2 conditions

    Perhaps I should be more specific:

    Sheet 1 has:
    Co. A 1
    Co. B 0
    Co. C 1

    Sheet 2 has:
    Co. A -1%
    Co. B 2%
    Co. C 5%

    I need to count the number of companies with 1 and positive growth. In the
    example, the answer would be 1 since co. c is the only that meets the
    criteria.


    "Andy" wrote:

    > Hi Flutie
    >
    > One option is to use SUMPRODUCT. Have a look here for some examples:
    > http://www.contextures.com/xlFunctio...tml#SumProduct
    >
    > Andy.
    >
    > "Flutie99" <[email protected]> wrote in message
    > news:[email protected]...
    > >i need to count the number of companies that are selected (using "1" or "0"
    > > in one column) and have posiitve growth rates (in another column). is
    > > there
    > > a countif function that lets me do this?

    >
    >
    >


  14. #14
    Flutie99
    Guest

    Re: countif question using 2 conditions

    figured it out. by the way, what does "--" do?

    "Flutie99" wrote:

    > Perhaps I should be more specific:
    >
    > Sheet 1 has:
    > Co. A 1
    > Co. B 0
    > Co. C 1
    >
    > Sheet 2 has:
    > Co. A -1%
    > Co. B 2%
    > Co. C 5%
    >
    > I need to count the number of companies with 1 and positive growth. In the
    > example, the answer would be 1 since co. c is the only that meets the
    > criteria.
    >
    >
    > "Andy" wrote:
    >
    > > Hi Flutie
    > >
    > > One option is to use SUMPRODUCT. Have a look here for some examples:
    > > http://www.contextures.com/xlFunctio...tml#SumProduct
    > >
    > > Andy.
    > >
    > > "Flutie99" <[email protected]> wrote in message
    > > news:[email protected]...
    > > >i need to count the number of companies that are selected (using "1" or "0"
    > > > in one column) and have posiitve growth rates (in another column). is
    > > > there
    > > > a countif function that lets me do this?

    > >
    > >
    > >


  15. #15
    Guest

    Re: countif question using 2 conditions

    Hi

    -- coerces a TRUE or a FALSE into being a number. If you type =TRUE into a
    cell, you get TRUE. If you type =--TRUE into a cell, you get 1. It's a
    simple way of making a TRUE result equal 1 and a FALSE result equal 0 - for
    calculation purposes.

    Andy.

    "Flutie99" <[email protected]> wrote in message
    news:[email protected]...
    > figured it out. by the way, what does "--" do?
    >
    > "Flutie99" wrote:
    >
    >> Perhaps I should be more specific:
    >>
    >> Sheet 1 has:
    >> Co. A 1
    >> Co. B 0
    >> Co. C 1
    >>
    >> Sheet 2 has:
    >> Co. A -1%
    >> Co. B 2%
    >> Co. C 5%
    >>
    >> I need to count the number of companies with 1 and positive growth. In
    >> the
    >> example, the answer would be 1 since co. c is the only that meets the
    >> criteria.
    >>
    >>
    >> "Andy" wrote:
    >>
    >> > Hi Flutie
    >> >
    >> > One option is to use SUMPRODUCT. Have a look here for some examples:
    >> > http://www.contextures.com/xlFunctio...tml#SumProduct
    >> >
    >> > Andy.
    >> >
    >> > "Flutie99" <[email protected]> wrote in message
    >> > news:[email protected]...
    >> > >i need to count the number of companies that are selected (using "1"
    >> > >or "0"
    >> > > in one column) and have posiitve growth rates (in another column).
    >> > > is
    >> > > there
    >> > > a countif function that lets me do this?
    >> >
    >> >
    >> >




  16. #16
    Dave Breitenbach
    Guest

    Re: countif question using 2 conditions

    Here is a better website which descibes in more detail the use of "--"
    http://www.xldynamic.com/source/xld.SUMPRODUCT.html

    "Flutie99" wrote:

    > figured it out. by the way, what does "--" do?
    >
    > "Flutie99" wrote:
    >
    > > Perhaps I should be more specific:
    > >
    > > Sheet 1 has:
    > > Co. A 1
    > > Co. B 0
    > > Co. C 1
    > >
    > > Sheet 2 has:
    > > Co. A -1%
    > > Co. B 2%
    > > Co. C 5%
    > >
    > > I need to count the number of companies with 1 and positive growth. In the
    > > example, the answer would be 1 since co. c is the only that meets the
    > > criteria.
    > >
    > >
    > > "Andy" wrote:
    > >
    > > > Hi Flutie
    > > >
    > > > One option is to use SUMPRODUCT. Have a look here for some examples:
    > > > http://www.contextures.com/xlFunctio...tml#SumProduct
    > > >
    > > > Andy.
    > > >
    > > > "Flutie99" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > >i need to count the number of companies that are selected (using "1" or "0"
    > > > > in one column) and have posiitve growth rates (in another column). is
    > > > > there
    > > > > a countif function that lets me do this?
    > > >
    > > >
    > > >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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