Formula returns #N/A

D

David

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word 2007 flash screen upside down and Word2007 cannot be used 0
formula error 1
Use TODAY() function as the criteria in a SUMIF formula 1
need help in fine-tuning a formula that removes blank cells in a column range 3
Countif Formula 1
Multiple Offset/Match formula returns "#N/A" 2
ISODD array formula 1
Calculation with a Blank or 0 Cell 3

Top