Prev: Excell - two conditions count if factors are true when negative nu
Next: how to remove page breaks from an existing document
From: Glenn on 6 May 2010 10:02
linda wrote:
> Formula to count if two conditions. I want to count column b when = "CAS"
> and if the number in column J is a negative number.
>
> I have tried =COUNTIF(B7:B21,"=CAS")=SUM(J7:J21,""<0)
> but it returns a "false" read.
>
> Column "b" are all words and Column "J" is numbers, but sometimes a negative
> number and I only want it to count if it is "0" or Less (negative)
>
>


http://www.contextures.com/xlFunctions04.html#SumProduct
 | 
Pages: 1
Prev: Excell - two conditions count if factors are true when negative nu
Next: how to remove page breaks from an existing document