Multiplying and Summing percents ignoring Text in some cells

[benntw]

In row 2 I have assigned weighted percents to multiply each row's current percent complete in columns Column J:S. Column T is my sum of all of them and is where my formula is. Currently I have to count a category as 100% even though it should be NA. I have tried iserror, isnumber, etc and have had no luck. If I put NA in any of the columns it errors out. I am hoping someone can unrack my brain on this. Below is my current formula before I gave any though about an NA being used.

=SUM(J5*J$2)+(K5*K$2)+(L5*L$2)+(M5*M$2)+(N5*N$2)+(O5*O$2)+(P5*P$2)+(Q5*Q$2)+(R5*R$2)+(S5*S$2)

Thank you.

 

[sheetspread]

sumproduct(J5:S5,$J$2:$S$2) does the same thing, and you can include an isnumber condition to avoid text errors.

 

[benntw]

Appreciate the help. I had to go with the long formula IFERROR(J6*J2,J2)+ . I tried your formula, but when the error happened it did not take row 2 and replace the NA with that percentage. I do how ever really like the formula if I use numbers only.

 

[sheetspread]

replace NA with what percentage? Here's one way to skip text:

Excel 2010
	J	K	L	M	N	O	P	Q	R	S
2	0.01	0.02	0.03	0.11	0.12	0.14	0.17	0.19	0.18	0.03
3
4
5	3	7	a	11	22	b	54	c	82	17
6
7
8	28.47
Sheet7

Cell Formulas
Range	Formula
J8	=SUMPRODUCT(--ISNUMBER($J$5:$S$5),$J$5:$S$5,$J$2:$S$2)

 

[benntw]

I didn't explain it clear enough. My result in column T should equal 100%. The weighted values in row 2 are 30%, 5%, 5%, 10%, 15%, 10%, 10%, 5%, 5%, 5%. When I did the IFERROR formula when there was an NA it claimed the weighted average. With doing that Column T added to 100%. Now I am working on a vertical solution. I appreciate your time you have taken on this.