Hey guys, I have a bit of code that generates a formula in specific cells, and for the most part works how I want it to, but I need to find a way to tell it if no match is found, to return a numerical value of zero. Right now the formula searches the workbook QB Output for the same invoice numbers found in the workbook the formula is in, if a match is found it adds up the items serviced and outputs a total. However, if the invoice number is not found the cell is left blank, which causes issues later in the code. So any help explaining to me how to make it return a value of "0" if no match is found, would be really helpful...

Range(Cells(4,  8), Cells(Bot, 8)).FormulaR1C1 = "=IF(SUMIF('[QB  Output.xlsx]Sheet1'!C4,RC3,'[QB  Output.xlsx]Sheet1'!C6)=0,"""",SUMIF('[QB  Output.xlsx]Sheet1'!C4,RC3,'[QB Output.xlsx]Sheet1'!C6))"