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?
Bookmarks