I am trying to use a sumproduct where one variable is to select all cells that are blank (" ") and the other variable where the value = #N/A. I also have a field value to add the number of occurrences.
Here is the formula I've used, but it does not seem to be working:
SUMPRODUCT(--($H$2:$H$13382=" "),--($I$2:$I$13382="#N/A"),N$2:N$13382)
Any ideas would be greatly appreciated.
Bookmarks