ExcelBanter - Need Function for Double If

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Need Function for Double If (https://www.excelbanter.com/excel-worksheet-functions/34996-need-function-double-if.html)

Jones

Need Function for Double If

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?

Duke Carey

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

RagDyer

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?

All times are GMT +1. The time now is 01:18 AM.