Hi All, In my sheet I have a cell that contains the following output in cell A66: G:\X\X\X\X\[1234.xls]12345 (This is actually a formula so the file location and filename will vary based upon the date but that's the output) In VBA I want to add a SUMIF that references the above output, so I've got this: Range("A66").Select folderfilename = ActiveCell.Value Range("C67").Select ActiveCell.Formula = "=SUMIF(" & folderfilename & "!$F$2:$F$781,A67, " & folderfilename & "!$O$2:$O$781)" Unfortunately I',m getting Run Time Error 1004 when running this. Any help would be massively appreciated.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA SUMIF

Thread starter Prejudicial
Start date Apr 7, 2022

Prejudicial

New Member

Apr 7, 2022

Hi All,

In my sheet I have a cell that contains the following output in cell A66:

G:\X\X\X\X\[1234.xls]12345

(This is actually a formula so the file location and filename will vary based upon the date but that's the output)

In VBA I want to add a SUMIF that references the above output, so I've got this:

VBA Code:

Range("A66").Select
folderfilename = ActiveCell.Value
   
Range("C67").Select
ActiveCell.Formula = "=SUMIF(" & folderfilename & "!$F$2:$F$781,A67, " & folderfilename & "!$O$2:$O$781)"

Unfortunately I',m getting Run Time Error 1004 when running this.

Any help would be massively appreciated.