Hello,
I have sumifs problem and I do not know what is the reason. I assume the problem is the date format because if I type manually the date on sheet1 then formula on sheet2 is working fine. The formula on sheet2 is calculate the amount in the actual month regarding the material number. Please note that on sheet1 and sheet2 there are more thousand data lines.
The data (on sheet1) coming from directly from my ERP system.
Do you have any idea what could be the solution?Please Login or Register to view this content.
Thank you in advance!
Bookmarks