The noun TILE has 2 senses: 1. a flat thin rectangular slab (as of fired clay or rubber or linoleum) used to cover surfaces. 2. a thin flat slab of fired clay used for roofing. Familiarity information: TILE used as a noun is rare. â¢ TILE (verb).
In the At each change in box, click the nested subtotal column. For example, using the example above, you would select Sport. In the Use function box, click the summary function that you want to use to calculate the subtotals. For example, using the example above, you would select Sum.nsert the outer subtotals. How to insert the outer subtotals. On the Data tab, in the Outline group, click Subtotal. The Subtotal dialog box is displayed. In the At each change in box, click the column for the outer subtotals. For example, using the example above, you would click Region.
2) You can use SUBTOTAL to ignore values in hidden rows. Often, we use hide rows feature in excel to remove irrelevant items from view. You can use SUBTOTAL with special type codes so that values in hidden rows are neglected. For eg. SUBTOTAL(9,A1:A10) finds the sum of values in cells A1:A10 where as SUBTOTAL(109,A1:A10) will find sum of values in visible rows only.