Forum Discussion
Hi - requiring assistance, much appreciated!
As is always true in Excel, there are many routes from Point A to Point B. How can you fix the situation so that #NA doesn't appear at the top of the sort?
One way, and only one way, would be to have whatever the formula is in column N wrapped in an IFERROR function, like this
=IFERROR(SUM(O2,P2,Q2),0)
which will cause a zero to appear instead of #NA. That's one way.
A better way (IMHO) would be to fix the formulas in columns O, P & Q so they're returning a value (possibly zero) rather than whatever it is that they're returning. In general, you want to fix a problem as close to the source as possible, rather than just putting a bandaid on a gaping sore,
It all has to do with what would be delivering a result with the highest integrity/reliability.
As is always true in Excel, there are many routes from Point A to Point B. How can you fix the situation so that #NA doesn't appear at the top of the sort?
One way, and only one way, would be to have whatever the formula is in column N wrapped in an IFERROR function, like this
=IFERROR(SUM(O2,P2,Q2),0)
which will cause a zero to appear instead of #NA. That's one way.
A better way (IMHO) would be to fix the formulas in columns O, P & Q so they're returning a value (possibly zero) rather than whatever it is that they're returning. In general, you want to fix a problem as close to the source as possible, rather than just putting a bandaid on a gaping sore,
It all has to do with what would be delivering a result with the highest integrity/reliability.
I've come up with a workaround to wrap columns o,p,q. Appreciated!
- You're welcome.