Treat Missing Values as 0?

[pceleri]

I've been working for sometime on creating an accurate payroll environment within excel, and I'm finally close, but ran into an issue I could use the expertise of this forum with. The workbook contains sheets for each month (January to December) separated by Quarterly sheets that populate from the appropriate monthly sheets, and a YTD sheet that sums the info from the Quarterly sheets. What I'm finding is that on the YTD sheet I'm getting missing value errors for the months that haven't come (or been entered yet). Is there a way to have excel treat these 0 value cells as a 0 and add up what is currently there? Here is an example of the code - [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]

=IFERROR(VLOOKUP(A22, January, 131, 0)+VLOOKUP(A22, February, 131, 0)+VLOOKUP(A22, March, 131, 0), 0)

For example, lets say that I have entered January payroll, February and March are blank (well not blank as many cells contain a formula waiting on hours worked to be entered), and the Quarter1 sheet will give a Missing Value error, or rather just display 0, instead of showing the value for January.

Thanks in advance
[/FONT]

 

[DanteAmor]

Try:

=IFERROR(VLOOKUP(A22, January, 131, 0), 0) + IFERROR(VLOOKUP(A22, February, 131, 0),0) + IFERROR(VLOOKUP(A22, March, 131, 0), 0)

 

[pceleri]

Thank you! That did the trick.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.