| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif Question | Excel Worksheet Functions | |||
| Sumif Question | Excel Discussion (Misc queries) | |||
| SUMIF Question | Excel Worksheet Functions | |||
| Question about SumIF | Excel Worksheet Functions | |||
| SUMIF Question | Excel Programming | |||
Linear Mode
