Count Unique Values in a column based on two other columns

[slam]

Happy Monday everyone!

On a worksheet named Summary, I am looking to count the number of unique values in column B where column D is blank, and where column E is 50 or greater. So far, I had this formula, without the unique piece, but not working anyway.

=countifs(Summary!D:D,ISBLANK,Summary!E:E,>49)

If I could get some help with this, and maybe the inverse, where DD is not blank, I think I could build all the other formulas I need.

Thanks!

 

[Fluff]

How about

=ROWS(UNIQUE(FILTER(Summary!B2:B2000,(Summary!D2:D2000="")*(Summary!E2:E2000>=50))))

 

[slam]

Perfect, thank you!

 

[Fluff]

You're welcome & thanks for the feedback.