Hello,
I've got a data table various things to lookup.
I use a list of variables to build the sumproduct from.
The issue I have is that while some variable fields are blank, it seems the sumproduct is returning a result on the "blank value" of the cell instead of ignoring it.
How do I get it to ignore blank cells in the variables?????

I've been using these two
=SUMPRODUCT((Channel=B25)*(Licensee=B26)*(State=B27)*(SalesRep=B28)*(SalesData))
=SUMPRODUCT(--(Channel=B25),--(Licensee=B26),--(State=B27),(Sales Data))