“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I have define 3 ranges per cell as:
1 = Satisfactory
0= Unaceptable
N/A= No Applicable
I want to SUM the cells and when the SUM of all cells is N/A I want to set up as 100%, if the sum of all cells is 1 and if the sum of al cells is "0" provide me 0%.
Permits/Authorizations Used 100%
0101 Part A Work details N/A
0102 Part B Work scope & description N/A
0103 Part C Specialty safety equipment 1
0104 Part D Safety precautions N/A

Solved by I. S. in 25 mins

Try to sum up different cells but some of the cells has #n/a

Solved by K. L. in 27 mins

How can I take the 3 largest numbers from a list of numbers and sum them?

Solved by X. D. in 18 mins

=SUM(SUMIFS(AC!$N$5:$N$1918,AC!$D$5:$D$1918,"1712",AC!$F$5:$F$1918,"M",AC!$H$5:$H$1918,{"EXP","MED","MISC"}))+SUM(SUMIFS(AC!$N$5:$N$1918,AC!$D$5:$D$1918,"1712",AC!$F$5:$F$1918,"MV",AC!$H$5:$H$1918,{"EXP","MED","MISC"}))*0.5+SUM(SUMIFS(AC!$N$5:$N$1918,AC!$D$5:$D$1918,"1712",AC!$F$5:$F$1918,"MR1",AC!$H$5:$H$1918,{"EXP","MED","MISC"}))+785

Solved by B. H. in 28 mins

The sum of NUMBERS, not text, add up to zero instead of the correct number.

Solved by D. D. in 27 mins