=SUMPRODUCT((J1:J100<1)*(B1:B1003))

"Jones" wrote:

I need to write a countif function with two dependent variables. My first
condition is that column J does not equal 1 and my second condition is that
column b is greater than 3.

Does anyone have a suggestion on how to embed both of these criterias in a
countif statement?