| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF to clsoed workbook
I have a workbook that i am trying to link to a closed workbook, and i am
getting an error message on the value. i know that sumproduct can be used but am unfamiliar with it, can someone help me my formula is =SUMPRODUCT('Z:\PURCHASED PRODUCT 2007.08\[PURCHASED PRODUCT 2007.08.xls]ORANGE CONC HOWEY'!$K15:K9999,"<="&A7,'Z:\PURCHASED PRODUCT 2007.08\[PURCHASED PRODUCT 2007.08.xls]ORANGE CONC HOWEY'!$Z15:Z9999) Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF to clsoed workbook
Try this:
=SUMPRODUCT(--('Z:\PURCHASED PRODUCT 2007.08\[PURCHASED PRODUCT 2007.08.xls]ORANGE CONC HOWEY'!$K15:K9999<=A7),'Z:\PURCHASED PRODUCT 2007.08\[PURCHASED PRODUCT 2007.08.xls]ORANGE CONC HOWEY'!$Z15:Z9999) -- Biff Microsoft Excel MVP "Susan" wrote in message ... I have a workbook that i am trying to link to a closed workbook, and i am getting an error message on the value. i know that sumproduct can be used but am unfamiliar with it, can someone help me my formula is =SUMPRODUCT('Z:\PURCHASED PRODUCT 2007.08\[PURCHASED PRODUCT 2007.08.xls]ORANGE CONC HOWEY'!$K15:K9999,"<="&A7,'Z:\PURCHASED PRODUCT 2007.08\[PURCHASED PRODUCT 2007.08.xls]ORANGE CONC HOWEY'!$Z15:Z9999) Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif across workbook tabs | Excel Worksheet Functions | |||
| SUMIF across multiple worksheets in another workbook | Excel Worksheet Functions | |||
| I need to use the sumif for a workbook, not a worksheet | Excel Worksheet Functions | |||
| sumif using other cell contents as workbook | Excel Discussion (Misc queries) | |||
| SumIf - Linked Workbook - #VALUE | Excel Worksheet Functions | |||
Hybrid Mode
