7db49c3c99eb854592129ad1267712f5 Weel 1 Subtotal Handout

Prévia do material em texto

SUBTOTAL function
The SUBTOTAL function returns a subtotal in a list or database.
The SUBTOTAL function has the ability to perform several mathematic functions such as sum, average, count, product, min, max and more
SUBTOTAL will provide dynamic totals when using filters
The SUBTOTAL function will ignore other subtotals in a list and only compute pertinent data
SUBTOTAL will ignore hidden rows
Use the SUBTOTAL function when filtering large data sets that will have different values based on the information being filtered
SUBTOTAL will commute data sets without the concern of double counting
Overview
Syntax
Tips and Tricks
Uses and Applications
=SUBTOTAL(Function_num,ref1,[ref2],…)
=SUBTOTAL(The function you would like to perform (I.e. Sum, Average, etc., Select the cell or range of cells you would like the compute)
Function
Input Criteria
Array
Excel Defined Criteria
1