sumif question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gary Keramidas - 17 Sep 2007 00:43 GMT

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)

Signature

Gary

Reply to this Message

JMB - 17 Sep 2007 01:14 GMT

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)

> 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)

Reply to this Message

Gary Keramidas - 17 Sep 2007 01:26 GMT

ok, thanks for that.

Signature

Gary

> Doesn't look like it. Sumproduct works on closed workbooks.
>
[quoted text clipped - 5 lines]
>> in workbook book1 with price closed:
>> =SUMIF([Price.xls]Margin!$A$2:$A$70,A12,[Price.xls]Margin!$C$2:$C$70)

Reply to this Message