Objective: I using a sumproduct formula to aggregate data from 2 columns in another sheet, 1 of which contains #NA values. Do the #NA values cause the sumproduct formula not to work and if yes, how can I convert the #NA's to something else. Here's the formula producing some #NA's.
Formula...