Occasionally external data errors cause a #N/A in a table and the error carries over into my totals. Is there any way I can keep the totals working normally (obviously without the values associated with the error)?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
dealing with #N/A in totals
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,259
- Office Version
- 365
- Platform
- Windows
See here for options: https://www.extendoffice.com/documents/excel/3268-excel-sum-column-ignore-na.html
However, if the thing returning the #N/A is actually a formula (that is maybe pulling your external data), it is usually better to update the formula to ignore errors, i.e.
=IFERROR(your original formula here, 0)
However, if the thing returning the #N/A is actually a formula (that is maybe pulling your external data), it is usually better to update the formula to ignore errors, i.e.
=IFERROR(your original formula here, 0)
Upvote
0
