I am usually making it by monthly totals , I want anaylse closely by daily movement
Find attached , need formula on c3 that should go check sheet 2 convert sales which are negatives into positives and returns
which are positives into negatives into the cells where the product belongs
I think it is related to SUMPRODUCT , as I use this for monthly fetch
=SUMPRODUCT((Sheet2!$D$2:$D$6=Sheet1!$A3)*(MONTH(Sheet2!$A$2:$A$6)=(COLUMN()-MIN(COLUMN(Sheet1!$C$2:$N$2))+1)),-Sheet2!$G2:$G6)
Bookmarks