two condition formula

[linda]

I am trying to count column "a" when a condition is true and then count
column "j" when the number is a negative.

I have tried =COUNTIF(B9:B23,"=COMP")+COUNTIF(J7:J22,""<0)
but I do not get the answer it should be. Column "b is words and column "J
is number that are negative so that why I choose <0.

Column B will have multiple names and column J is the difference in late days.

 

[Jacob Skaria]

Hi Linda

Try the below

=SUMPRODUCT((B9:B23="COMP")*(J9:J23<0))

If you are using XL2007 try help on COUNTIFS()