Hello Friends,
Pls convert the below sumif formula to sumproduct as sumif does not work on closed workbook
Regards,
Humayun
Pls convert the below sumif formula to sumproduct as sumif does not work on closed workbook
Excel Formula:
=SUMIFS('C:\OneDrive\Documents\DATA ENTRY.xlsm'!orders_value,'C:\OneDrive\Documents\DATA ENTRY.xlsm'!orders_po_shipment_date,">="&C$3,'C:\OneDrive\Documents\DATA ENTRY.xlsm'!orders_po_shipment_date,"<="&C$4,'C:\OneDrive\Documents\DATA ENTRY.xlsm'!orders_supplier,$B6,'C:\OneDrive\Documents\DATA ENTRY.xlsm'!orders_customer,"towel world")
Regards,
Humayun