Hello everyone,
So I'm trying to fill data to sheet "PROD BILKON" from the sheet "check" using the SUMPRODUCT function when ORDER NO and COLOR is matching, the thing is that I'm having the value 0 when I apply the function I did it with the Column CUTTING and I'm going to apply the same function to the other columns.
Note: all the fields in the sheet "check" are in TEXT format cell, I had to change all of them and do it like that because I export this sheet "check" from a tracking system otherwise I have different values.
would you please help me with it if you can?
Thank you.
Bookmarks