ExcelBanter - sumif question

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - sumif question (https://www.excelbanter.com/excel-programming/397569-sumif-question.html)

Gary Keramidas

sumif question

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

JMB

sumif question

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

Gary Keramidas

sumif question

ok, thanks for that.

--

Gary

"JMB" wrote in message
...
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

All times are GMT +1. The time now is 12:12 AM.