Change sumif formula to sumproduct

[hrayani]

Hello Friends,

Pls convert the below sumif formula to sumproduct as sumif does not work on closed workbook

=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

 

[hrayani]

Ok Did it myself - thanks

=SUMPRODUCT(('DATA ENTRY.xlsm'!orders_value)*('DATA ENTRY.xlsm'!orders_po_shipment_date>=C$3)*('DATA ENTRY.xlsm'!orders_po_shipment_date<=C$4)*('DATA ENTRY.xlsm'!orders_supplier=$B6)*('DATA ENTRY.xlsm'!orders_customer="towel world"))