from Pierre Leclerc at http://www.excel-vba.com
Excel-lence.net - by Affordable Solutions
Lesson 16 of 30: The SUBTOTAL Function The Excel function SUBTOTAL is a function that can execute 11 types of calculations. SUBTOTAL is a very useful formula for analysis of data directly from the database. It will sum, count, calculate average....of the records that have been filtered in a database.
The
syntax is very easy: In plain English: Execute calculation number 9 on all filtered records of range A2 to A50. If no filter is applied the calculation is executed using all the cells in the range. Calculation
types: Types 7, 8, 10 and 11 are for users interested in statistics. As for type 6...you tell me. |