sumif question

  • Thread starter Thread starter Gary Keramidas
  • Start date Start date
G

Gary Keramidas

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)
 
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)
 
ok, thanks for that.

--


Gary


JMB said:
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 said:
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)
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To find rate of each item from item.xls and to copy price.xls 7
Little help on Autofill please 4
Excel sum if and closed workbooks 2
help with a basic code? 0
Dynamic Named Range 4
Help with SUMIF & AND function 2
Hovering over a cell and seeing a data set for the sum in the cell 2
SUMIF and SUMIFS Error 3

Back
Top