COUNTIF (2) Conditions

[Featherk]

I'm trying to count with (2) conditions: and I'm using COUNTIF
Example
Column A has 450 lines items and each line item is assigned to various people

Column B has various Delta's for days late. (i.e. <10 days late, <30 Days late, etc

My first Count I can get, My formula is COUNTIF (I1:I450, "<10") = 100

Now I want to count of the 100 how many are Jane Doe


I've tried this COUNTIF (B1:B450, "<10") and, COUNTIF (A1:A450, "<Jan Doe") - this does not work

 

[barry houdini]

The "double dash" is known as double unary minus. In this scenario it is used to co-erce an array of TRUE/FALSE values to an array of 1/0 values. SUMPRODUCT needs numeric values to calculate.

You can try a small experiment

If cell A1 is blank then this formula in another cell

=A1="" should return TRUE but if you change the formula to

=--(A1="") then the answer will be 1

You could also use

=(A1="")+0 or =(A1="")*1 or others

 

[Analyze This]

thank you very much Barry, I can most certainly see why that would come in handy!