A ALAMZEB Member Oct 7, 2016 #1 hi guys.i am calculating DIFOT but pivot table oest wrk bcuse of we ae shipping in different dates can we creaate a formula tha will sumif al QY to latest date (see colums Y) bsed on porchase order (column K) ad Part # (column A) Attachments chandoo sumif.xls chandoo sumif.xls 32 KB · Views: 17
hi guys.i am calculating DIFOT but pivot table oest wrk bcuse of we ae shipping in different dates can we creaate a formula tha will sumif al QY to latest date (see colums Y) bsed on porchase order (column K) ad Part # (column A)
B bosco_yip Excel Ninja Oct 7, 2016 #2 ALAMZEB said: ........sumif all QTY to latest date (column Y) based on purchase order (column K) and Part # (column A) Click to expand... Try.......... In Y2, enter formula : =SUMIFS(O:O,A:A,A2,K:K,K2) Regards
ALAMZEB said: ........sumif all QTY to latest date (column Y) based on purchase order (column K) and Part # (column A) Click to expand... Try.......... In Y2, enter formula : =SUMIFS(O:O,A:A,A2,K:K,K2) Regards
A ALAMZEB Member Oct 7, 2016 #3 Hi bosco , its doesnt work, its giving me 128 in all column i need only sum of qty invoices aguiant latest date of delievry
Hi bosco , its doesnt work, its giving me 128 in all column i need only sum of qty invoices aguiant latest date of delievry
B bosco_yip Excel Ninja Oct 7, 2016 #4 ALAMZEB said: Hi bosco , its doesnt work, its giving me 128 in all column i need only sum of qty invoices aguiant latest date of delievry Click to expand... Maybe…….. In Y2, copy down : =IF((COUNTIFS(A$2:A2,A2,J$2:J2,J2)=1)*(INDEX(MAX((A$2:A$1000=A2)*(J$2:J$1000)),0)=J2),SUMIFS(O:O,A:A,A2,K:K,K2),"") Regards
ALAMZEB said: Hi bosco , its doesnt work, its giving me 128 in all column i need only sum of qty invoices aguiant latest date of delievry Click to expand... Maybe…….. In Y2, copy down : =IF((COUNTIFS(A$2:A2,A2,J$2:J2,J2)=1)*(INDEX(MAX((A$2:A$1000=A2)*(J$2:J$1000)),0)=J2),SUMIFS(O:O,A:A,A2,K:K,K2),"") Regards
