Unfortunately the SumProduct equation will read the #N/A and provide that for the answer as well.
The formula Sumif(Range,"<>#N/A") will treat the #N/A as a null value, providing me with the sum of the values in the column other than #N/A.
Thank you for answering though
Bookmarks