If broken down it should be like this:

=IF( SUMIF('C:\Users\chrish\Desktop\JC FINAL\[quickbooks file.xlsx]Sheet1'!$D:$D,$C4,'C:\Users\chrish\Desktop\JC FINAL\[quickbooks file.xlsx]Sheet1'!$F:$F)
= 0, "",
SUMIF('C:\Users\chrish\Desktop\JC FINAL\[quickbooks file.xlsx]Sheet1'!$D:$D,$C4,'C:\Users\chrish\Desktop\JC FINAL\[quickbooks file.xlsx]Sheet1'!$F:$F)
)

Im not sure why the formula would be cut like that though.
Check to make sure the script is copied correctly. Especially this:


'Add the formulas
Range(Cells(4, 8), Cells(Bot, 8)).FormulaR1C1 = "=IF(SUMIF('[quickbooks file.xlsx]Sheet1'!C4,RC3,'[quickbooks file.xlsx]Sheet1'!C6)=0,"""",SUMIF('[quickbooks file.xlsx]Sheet1'!C4,RC3,'[quickbooks file.xlsx]Sheet1'!C6))"