Here is an example where there were "N/A" responses that we did not want to count. So the denominator counts as "1" if the response was Yes or No. (but zero of "N/A" or blank)

The numerator count yes as a 1, else 0.

(Case([POS Data Representation Criteria Met], "Yes", 1, "No", 0, 0) +

Case([POS Reference # Criteria Met], "Yes",1, "No", 0, 0) +

Case([POS Registration Criteria Met],"Yes",1, "No", 0, 0) +

Case([POS Verify Payments Criteria Met], "Yes",1 , "No", 0, 0) +

Case([POS Verify Summary Page Criteria Met], "Yes",1 , "No", 0, 0) +

Case([POS Attachments Criteria Met], "Yes",1, "No", 0,0))

/

(

Case([POS Data Representation Criteria Met], "Yes", 1, "No", 1, 0) +

Case([POS Reference # Criteria Met], "Yes",1, "No", 1, 0) +

Case([POS Registration Criteria Met],"Yes",1, "No", 1, 0) +

Case([POS Verify Payments Criteria Met], "Yes",1 , "No", 1, 0) +

Case([POS Verify Summary Page Criteria Met], "Yes",1 , "No", 1, 0) +

Case([POS Attachments Criteria Met], "Yes",1 , "No", 1, 0))