Count unique values in a column for each row that meets 3 criteria

Hello All -

My goal is to have a formula that returns the count of Unique IDs that meet three criteria. The ID list will include blanks.

Needing to perform approx 250 queries against 5000 lines.

Have been using array formulas for other calcs in the sheet.

Sample attached including criteria.

Thanks in advance.

Hello,

How do you generate the RKID?

If it's something that's based on the criteria (adding the cells B10,C10 and D10) you could do a countif on it.

i.e. =countif(E:E,$V$5) -->$V$5 being where you enter the RKID

Cheers,
C