If I have to explain this once more...

Microsoft Excel. You have a big spreadsheet, essentially a table of data like your third quarter financial results, your product catalogue or the scores from the weekly pub quiz. Its too big to see all the data at once.

Select the single cell that is below the row of column titles and to the right of any row titles (like the competitors' names) Drop down the "Window" menu and click "Freeze Panes". Now the row and column titles will stay on-screen while you scroll around the rest of the data.

Now select any cell in the table, drop down the "Data" menu, click Filter and then AutoFilter. Drop down arrows appear next to the column titles (it's a good idea if your column titles are all on one row, if not make them one row and use text wrapping to use multiple lines in that row). You can filter the list on any column to show, for instance, all the Automotive division's products.

Finally, with the table filtered in some way, go to the bottom of a numeric column, select the next cell down and click the AutoSum toolbar button (Greek Sigma symbol). Instead of a "Sum()" functionyou get a"Subtotal(9,)" function. Complete the range and accept the formula. The total will include only the filtered data.

For some odd reason this AutoSum subtotal trick only works for Sum (the button default). If you want a count (COUNTA), use Sum then replace the 9 by 3. The online help system has a handy list of subtotal function numbers, just search for "subtotal function".