Doesn't look like it. Sumproduct works on closed workbooks.

=SUMPRODUCT(--([Price.xls]Margin!$A$2:$A$70=A12),[Price.xls]Margin!$C$2:$C$70)


"Gary Keramidas" wrote:

sumif won't work on a closed workbook, will it?

for example
in workbook book1 with price closed:
=SUMIF([Price.xls]Margin!$A$2:$A$70,A12,[Price.xls]Margin!$C$2:$C$70)


--


Gary