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