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?