Loading...

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

7,611 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

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.

  • Category

  • License

    • Standard YouTube License

Loading...

Advertisement
to add this to Watch Later

Add to

Loading playlists...