Excel Tips, Tricks and Consulting & Training Services for All Levels

Excel provides an easy way to sum a range of cells based on a given criteria.  There are many ways this can be used but the example we are going to look at today is summing a range while ignoring #N/A’s in the same range.  Without ignoring #N/A, the result of the sum will be […]