Good morning.

I have the following formula that I am currently using in my Consolidated Report (separate workbook - total of 4 workbooks involved here):

=IFERROR(('[WORKBOOK1.xlsm]Breakdowns'!$D$12+'[WORKBOOK2.xlsm]Breakdowns'!$D$12+'[WORKBOOK3.xlsm]Breakdowns'!$D$12),"-")

The current link values I am picking up are 0.8 in WORKBOOK1-Breakdowns; 0.0 in WORKBOOK2-Breakdowns; and 0.9 in WORKBOOK3. The result of the formula is "-" when it should be 1.7. I believe it is because there is a string "-" ( being used in formula. Not sure. However, my attempts to fix this have failed. Is there a Formula and/or Array Formula that I can use to solve this.

I want the formula to do error trapping for strings, #DIV!; #VALUE!; and #N/A.

Is this possible? Again, the above WORKBOOKS 1-3 consist of a lot of linked data within them and now I have to do a Consolidated Version off of them.

Thanks a bunch for your assistance. Deanna