I have a cell range that using a LOOKUP and =OFFSET(..,MATCH....). some of the values returned are #N/A, which is expected. I want to make u SUM to all cells in that range in the end of the column (that do not contain the result #N/A) but i can not!