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?

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

Try this:

=SUMPRODUCT((B1:B503)*(J1:J50<1))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Jones" wrote in message
...
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?