One issue that can come up in adding up lists with subtotals and hidden rows is that the usual sum() will exclude hidden rows from your calculations. Equally if you have subtotals – you often don’t want those included in your calculations… So Microsoft have come up with a new function – called – which solves that problem.

In a completely random aside – I kept hearing “aggy, aggy, aggy” as I was preparing this video and I realised that it comes from this video – Maniac 2000 .”4,3,2,1…TAKE THIS HOUSE TO THE MAXIMUM!… You can hear the “oggy, oggy, oggy” bit at 2:48 in the video.

You can view the video here of me working through some of the options.  You can download and practise with the file here