Use something of the form:

=IF(ISERROR(your_formula),"",your_formula)

--
Gary''s Student - gsnu201001


"David" wrote:

I have a formula in cell B8
=INDEX(Sheet1!$A$2:$A$1201,MATCH(,COUNTIF($B$1:$B7 ,Sheet1!$A$2:$A$1201),))
with ctrl+shift+enter but it returns #N/A

1st of all, can I return a blank or a 0 if it cannot calculate the formula?

2nd, if it is there, how can I have a formula reading from this which says
if B8 = #N/A = 0 or calculate a sum formula if the answer is not #N/A?

Thanks