Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Aug 6, 2012
Download Excel File: http://people.highline.edu/mgirvin/Ex... This video see four methods to add numbers from various ranges that might have #N/A errors: 1. SUM, IF and ISNUMBER functions to add and avoid #N/A errors when you can highlight whole row. 2. Use CHOOSE Function and an array constant to "mash Together" noncontiguous ranges. 3. Learn about the syntax for array constants: comma is for column and semi-colon is for row 4. SUM, CHOOSE, IF and ISNUMBER functions to add from noncontiguous ranges and avoid #N/A errors. 5. Best solution: Excel 2010 Function AGGREGATE to add from non-contiguous ranges and avoid #N/A errors. 6. Excel 2013 Function ISNA with SUM function to add from non-contiguous ranges and avoid #N/A errors.