SUMPRODUCT with Error in Range

[scottjschultz]

Is there a way to create a SUMPRODUCT that ignores errors in the range?

 

[FormR]

Hi, have you tried just wrapping the range in an IFERROR() function - for example:

Book1
	A	B	C	D
1	5	2		129
2	8	4
3	3	#N/A
4	4	5
5	5	#VALUE!
6	7	5
7	8	1
8	7	#NAME?
9	8	3
10	9	#REF!
Sheet1

Cell Formulas
Range	Formula
D1	D1	=SUMPRODUCT(A1:A10,IFERROR(B1:B10,0))
B3	B3	=NA()
B5	B5	="A"+0
B8	B8	=A
B10	B10	=INDEX(A1,2)

 

[scottjschultz]

Genius!