Tech Tip: Excel and Subtotals

clive All, Excel, Tech Tip

If you use SUM() in Excel to calculate totals, you may want to know about the SUBTOTAL() function, which does a similar job, butbetter. SUBTOTAL takes 2 arguments – the first is a ‘magic number’, that tells it what you want to do; the second is a range of data to be totalled. Here’s what the magic numbers do: 1 …