Excel Magic Trick 960: Add Noncontiguous ranges that have #N/A Errors

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT960-963.xlsx Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm 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.