Having problem while filling data from a sheet into another.

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.

If you are simply trying to return the text date, try

Formula:

Please Login or Register  to view this content.

This is an array formula & needs to be confirmed with Ctrl Shift Enter

Did you confirm the formula with Ctrl Shift Enter rather than just enter?
If so you in the formula bar you should see the formula wrapped in {}

I'm so sorry I didn't see the line below the function box, I confirmed it. it works thank you.

Perfectly worked, Thank you very much.

You're welcome & thanks for the feedback