Ignore if NA in index/match

Hello,

I'm trying to add up a bunch of data using a series of index/match functions. For example, =(index/match + index/match + index/match, etc...) I'm using the match function to give me the column number. However, it's possible that there may not be a match, and thus the index/match function will return a value of #N/A.

Is there a way to make it so that if it returns a value of #N/A, either ignore it or give it a value of 0. I know I can use the ISNA function, but that would require that I create an If function for each index/match term.

I was wondering if there was a quicker way to accomplish this.

Thanks!

Can you post your full formula?

I would still recommend posting your full formula - Maybe you can use an array formula to shorten the whole thing..