Fix SUMIF to return value of zero if match isn't found

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...

Please Login or Register  to view this content.

change the """" to 0