May 6, 2013 at 11:58 pm doesn’t work with NA() is cell… any alternative to sum cross sheets with NA() ? Reply Mynda Treacy May 7, 2013 at 8:50 pm Get rid of the NA errors by wrapping the formulas in anIFERROR function. Kind regards, Mynda. Reply April 25, 2013 at 10:18...
The -- in front of the LEFT function is a trick we need to play on Excel to force it to treat the result from the LEFT function as a number rather than a text value. It does this by turning it into a negative number then back again (that's what the -- does). The only way E...