Formula

[sitelbanat]

Does anyone know how to change this formula to subtract the inverse of of the value in E69:E82.

=COUNTIF(O69:O82,">0")+SUMPRODUCT(--(O69:O82>0),--(ISNUMBER(E69:E82)),E69:E82)

 

[sitelbanat]

=COUNTIF(O69:O82,">0")-(1-SUMPRODUCT(--(O69:O82>0),--(ISNUMBER(E69:E82)),E69:E82))

HOW DO I CHANGE THIS FORMULA, TO +1 IF THE TOTAL VALUE OF E69:E82 <0.

IS IT AN AND FORMULA?

 

[sitelbanat]

I still get the same result.

All I need is if the total value of E69:E82 is <0 then add 1 to the total count amount, if not then dont do anything

=COUNTIF(O69:O82,">0")-(1-SUMPRODUCT(--(O69:O82>0),--(ISNUMBER(E69:E82)),E69:E82))

so this is correct so far, but I want to add another if statement to the formula at the end of it

 

[NBVC]

This is how I interpret your above post.

Is it what you need?

=IF(SUM(E69:E82)<0,COUNTIF(O69:O82,">0")-(1-SUMPRODUCT(--(O69:O82>0),--(ISNUMBER(E69:E82)),E69:E82)),"")

 

[sitelbanat]

Well, all I want to do is add to my formula which is below another IF statement at the end of it


=COUNTIF(O69:O82,">0")-(1-SUMPRODUCT(--(O69:O82>0),--(ISNUMBER(E69:E82)),E69:E82))

I want the if statement to total value of E69:E82 that are selected and if its <0 then add 1 to the total count amount, if not then dont do anything