| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif using other cell contents as workbook
Hi,
Can anyone help? i need to create a sumif formula or vba macro to carry out the following: ( where "this word" is in E15 on the sheet) =sumif(S:\Purchasing\["November 2005".xls]Front Order Sheet!B10:B1010,C2,S:\Purchasing\["November 2005.xls"]Front Order Sheet!F10:F1010) where "November 2005" is in the formula, i need this to be collected from cell E15 as it is different for each month so it looks in the relative month workbook. can anyone help? regs, Nigel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Export TextBox contents to new workbook. | Excel Discussion (Misc queries) | |||
| Write Contents of TextBox to new Workbook | Excel Discussion (Misc queries) | |||
| Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
Threaded Mode
