How to only count rows that are current (fulfil a criteria)

Hi,
I only want to count client who are on the ACTIVE waiting list. Once the referral is complete, the row greys out and I do not want these rows to be counted in the "Number of clients waiting" table. I am wondering what formula would do this?

Thanks!

To enter in B13:

=COUNTIFS(T_Referral[Referral completed],"",T_Referral[Priority],RIGHT([@[Priority Rating]],1))

This will count how many rows have a blank cell under "Referal complete", and also have the correct priority rating.


To enter in C3:

=IF(B3="","",(TODAY()-B3))

This checks for a blank cell, and if so it returns a blank.