Looked online can't find an answer to this seemingly easy question!

i have multiple cells in a row with formula's some showing #DIV/0! as no data yet to make the formula work. at the end of these 200 or so rows i want the average but obviously don't want it to return #DIV/0!. other than deleting all the cells with #DIV/0! what formula can i use to tell excel to ignore cells with #DIV/0!