Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF for 2 conditions | Excel Worksheet Functions | |||
countif two conditions | Excel Discussion (Misc queries) | |||
COUNTIF with two conditions | Excel Worksheet Functions | |||
How can I use COUNTIF to sum for two conditions? | Excel Worksheet Functions | |||
COUNTIF Question | Excel Worksheet Functions |