This tutorial explains how to use the Subtotals feature in Microsoft Excel and how the CountIF function may be a better option. There is also a quick look at Excel filters. These topics are covered on the advanced Excel course at http://www.itseasy.co.uk