One of my bugbears is a report that includes a # error, such as #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! My eye is drawn to the error and I'm always thinking what other errors are there in the analysis rather than focussing on the information presented (which is probably correct!). In Excel 2010 onwards the IFERROR function is available to resolve this problem, previously and I still see it today, the IF function is used to evaluate the formula, for example =IF

The SUBTOTAL function can be used with a variety of calculations, such as SUM, AVERAGE, COUNT and many more. We will look at the most common used calculation SUM in this example. The SUBTOTAL function is useful when you have a list where there are multiple sum totals included in it. By using the SUBTOTAL function you can add up the individual items and exclude the totals so that they are not double counted. Why Use SUBTOTAL It allows you to return the subtotal of a list, inc