Percentage Complete for text fields with variable N/A value

Edited after re-reading your post

smodkins in my example the columns are Check1 to Check 9.

CheckItems is a calculated column with the formula

=IF(Check1="N/A",0,1)
+IF(Check2="N/A",0,1)
+IF(Check3="N/A",0,1)
+IF(Check4="N/A",0,1)
+IF(Check5="N/A",0,1)
+IF(Check6="N/A",0,1)
+IF(Check7="N/A",0,1)
+IF(Check8="N/A",0,1)
+IF(Check9="N/A",0,1)

The CheckClear is a calculated column set to 0 decimal places and the ClearPC column is a calculated column set to 0 decimal points and as a percentage. The formula for the CheckClear is

=IF(Check1="Passed",1,0)
+IF(Check2="Passed",1,0)
+IF(Check3="Passed",1,0)
+IF(Check4="Passed",1,0)
+IF(Check5="Passed",1,0)
+IF(Check6="Passed",1,0)
+IF(Check7="Passed",1,0)
+IF(Check8="Passed",1,0)
+IF(Check9="Passed",1,0)

The formula for the ClearPC column is =CheckClear/CheckItems

See the post below for an image of the result.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)