Conditional Count of Multi Columns with Filters

Hello,   I have a table with the following 5 columns:    Customer ID Loan 1 Loan 2 Loan 3 Loan 4 Cust1 A D     Cust2 B A C D Cust3 D       Cust4 B A D     ...