I am trying to use a sumproduct function with IF and Text.
I want to see that if the value of the sumproduct function is "blank" or
"specific text" then return another value, if not then return the value of
the sumproduct function
Thanks