#DIV/O! Go away!

[georgegovensky]

Hello Excel Forum folks. Looking for some easy help Im sure for most of you.

1. I do not want to see the #DIV/0! in any of the cells on Doc Sheet from D4:M18. Instead I want to see "NA" and still maintain the sum function. Also some of the totals on Row 20 of Doc sheet may come up with Div/0.

2. Is there any way I can make the Date and gui calendar instead of just typing it in?

Thanks

[TMS]

Use IFERROR. For example:

I4: =IFERROR(INDIRECT("'" & $A4 &"'!U" &MATCH($B$2,INDIRECT("'" & $A4 &"'!A:A" ),0)),0)


Regards, TMS

[georgegovensky]

Thank You TMShucks. Works like a charm.

[TMS]

You're welcome. Thanks for the rep.