Would like to ignore the cell value of #NA in a SUM formula. The #NA is there because it represents future data from a worksheet that is yet to be completed. I know I have accomplished this in the past, however not having any luck remembering how I did this.

Thanks

tslayer