# Get instant live expert help on sum of n numbers

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

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

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