Frequency with Multiple Criteria IF/AND?

[sinfinite]

Hi There,

I'm trying to create a distribution table for frequency of certain counts and how many times it occurs in a range of numbers but wanted to have criteria to make it more specific.

For example... I would to see how many Type A with a non-blank status appears since right now I can only find frequency if it is A, B, C, D, etc.. and the status column is completely disregarded.

I've tried something like =FREQUENCY(IF(AND(SHEET1!$P$2:$P$26983="A",SHEET1!$Q$2:$Q$26983<>""),SHEET1!R2:R26983),SHEET2!T2:T9) which gives me a $Value, assuming AND() is not the correct option here with arrays.

(OR =FREQUENCY(IF(AND($A$2:$A$25="A",$B$2:$B$25<>""),$C$2:$C$25),F2:F9) for the example spreadsheet).

In Short, how can I get the frequency of X type as long as the Status on Column B is not blank?

Thank you, attached is a spreadsheet.

[Izadi]

Hi,
FREQUENCY(IF((($A$2:$A$25="A")*($B$2:$B$25<>""))=1,$C$2:$C$25),$F$2:$F$9)

[sinfinite]

Thanks! Works like a charm, just wondering what does the =1 on the bold section mean?

FREQUENCY(IF((($A$2:$A$25="A")*($B$2:$B$25<>""))=1,$C$2:$C$25),$F$2:$F$9)