For analytics, it is highly recommended to always have subtotal at the top of any table that contains numbers.
Syntax: SUBTOTAL(function_num,ref1,[ref2],...)
Where:
function_num = The number 1-11 or 101-111 that specifies the function to use for the subtotal
ref1 = The first named range or reference for which you want the subtotal
Ref2 = Optional. Additional range if any
There are 2 types of subtotal:
Type 1: Value from 1-11. It includes hidden values in subtotal range
Type 2: Value from 101-111. It ignores hidden value in subtotal range
No comments:
Post a Comment