in [Functions]

Prev: formula to return value from a matrix - I know hor and vert va
Next: Excell - two conditions count if factors are true when negativenu
From: linda on 6 May 2010 09:55 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)
From: Gary''s Student on 6 May 2010 10:01
=SUMPRODUCT((B7:B21="CAS")*(J7:J21<0)) -- Gary''s Student - gsnu201002 "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) > > |