Hi,


I have 2 identical sumproduct fuctions as follows:

=SUMPRODUCT(--($G$4:$G$1215>=G1222),--($G$4:$G$1215<=G1223),--($L$4:$L$1215="*XYZ*"))

Results with incorrect value = 0

=SUMPRODUCT(--($G$4:$G$1215>=G1222),--($G$4:$G$1215<=G1223),--($L$4:$L$1215=G1220))

Results with correct value = 3

Both G1220 or "*XYZ*" represents the same reference but why is it profiding different results?

"XYZ" represents a company & I'm want to count the total instances that "XYZ" has been assigned a job during a specified duration, in this instance, during the month of October.

Right now, the data is being extracted from a data log that I can't touch, which is part of the reason I would like to use the "*XYZ*" (wildcard) with the intent to make sure it captures the company, in case someone does not enter properly or adds extra space.

Now, I'm trying to figure out why I'm getting different results for identical functions that should that should provide the same results.

Once, I have this function, I would like to copy it into a new file

How can I use the same intent & be a 100% confident that the function in the new file is extractring properly from my datalog file? Feel free to make up new file.

I would attach a file but for some reason, I'm not able too.


Thanks