From the Not Just Numbers blog: I'm sure most of you are familiar with the SUM command for totalling ranges of cells, but have you heard of the SUBTOTAL command? - and if so, do you know what it does?

Most of us probably associate outlines with textual information rather than numerical data. In Excel, however, you can use outlines (and the accompanying Subtotal tool) to break data down into logical ...