Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF from another workbook
Right here we go:
Get file to 'read' - (file = Application.GetOpenFilename) If the cell in the current book contains a formuls do nothing If not then do the equivelent of this formula: =IF($C8"",SUMIF([file]Sheet1!$D:$D, $C8, [file]Sheet1!$E:$E),"") move down one cell and repeat do until column end. when it goes down each row the SUMIF would need to increment C9 then C10 etc etc Any help will be much appriciated. Cheers Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif linked to different workbook | Excel Worksheet Functions | |||
SUMIF has slowed down the workbook | Excel Worksheet Functions | |||
SUMIF to clsoed workbook | Excel Discussion (Misc queries) | |||
Sumif across workbook tabs | Excel Worksheet Functions | |||
SumIf - Linked Workbook - #VALUE | Excel Worksheet Functions |