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?

Hi Flutie

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

Andy.

"Flutie99" wrote in message
...
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?

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" wrote in message
...
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?

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" wrote in message
...
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?

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" wrote in message
...
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?

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" wrote in message
...
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" wrote in message
...
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?